This discussion is archived
1 Reply Latest reply: Feb 19, 2013 11:09 AM by orafad RSS

how to use multipule join in update stmt

947771 Newbie
Currently Being Moderated
hi,

i have a query in mssql i want to translate it using oracle 11g r2 latest sysntex

UPDATE trips
SET locations = trips.city + ', ' + poi.city
FROM trips INNER JOIN poi
ON poi.trip_guid = trips.guid

where trips.trip_guid =1


UPDATE trips t
SET locations = t.city + ', ' + p.city
FROM poi p
ON p.trip_guid = t.guid

where t.trip_guid =1

please tel me how i can write it in oracel 11g r2

i also show there is mearge statmet is it sql or plsql

yours sincerely

Edited by: 944768 on Feb 19, 2013 4:20 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points