Oracle. Reference to combined value from mult columns and tables - TechRepublic
Question
April 7, 2016 at 09:46 PM
yverkhovykh

Oracle. Reference to combined value from mult columns and tables

by yverkhovykh . Updated 10 years, 1 month ago

select ru.num || bu.grid || gu.place comb_id from
ru
,bu
,gu
,ku
where ru.id = bu.id and ru.id = gu.id and ku.id = comb_id

doesn’t work when i do it like this. complains that i can’t reference to multiple tables.

please help

This discussion is locked

All Comments