Figure 5: New scalar fullselect support UPDATE MyExchangeRates m SET conversion_rate= (SELECT rate FROM EuropeRates e WHERE e.countryid=m.country_id UNION SELECT rate FROM AsiaRates a WHERE a.countrycode=m.country_id)
UPDATE MyExchangeRates m SET conversion_rate= (SELECT rate FROM EuropeRates e WHERE e.countryid=m.country_id UNION SELECT rate FROM AsiaRates a WHERE a.countrycode=m.country_id)