a union query with parameter from upper table
igweNov 15 2010 — edited Nov 15 2010Hi all, I have a challenging query to write.
Something like this:
select a.name, b.car, c.dog
from al a, bl b, cl d
union
select '' name, '' car, f.dog
from fl f
where f.dog_id = c.dog_id (using dog_id from upper union)
Is something like this possible? Or is there a better way to write it?
Many thanks