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