5/15/2024 2:34:26 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.
|
|
|
|
Updates containing subqueries?
Posted: 23 Jan 07 10:33 AM
|
fiogf49gjkf0d I am trying to update records in table A with data from table B using an inner join. Parses great in T-SQL, just won't parse in SLX or SLX OLEDB:
update sysdba.gac_airport
set lat = b.lat, lon = b.lon, TFGMT = b.TFGMT
from sysdba.c_airport_update b left outer join sysdba.gac_airport a on b.airportid = a.acbaseicao
Tried with sysdba, without- no dice. Any ideas what it is choking on? 
Thanks, Michael |
|
|
|
Re: Updates containing subqueries?
Posted: 23 Jan 07 1:19 PM
|
fiogf49gjkf0d This is not supported. Try using a sub query (Not tested so please do the legwork)
UPDATE
gac_airport
SET
lat = (SELECT b.lat FROM c_airport_update b WHERE b.airportid = gac_airport.acbaseicao),
lon = (SELECT b.lon FROM c_airport_update b WHERE b.airportid = gac_airport.acbaseicao),
TFGMT = (SELECT b.TFGMT FROM c_airport_update b WHERE b.airportid = gac_airport.acbaseicao)
Timmus |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|