OUTER join question
Posted in 1999
Respectful — — source: Informix-list mailing list archive (1991-1998)
I want to do a select which selects a master table and it's 5 child tables,
via an outer join. I also want to outer on the children's child tables. It
will return one huge row for each combo(?),
Would this be the syntax? (abbreviated)
select from
master,
outer (child1,outer child1child)
outer (child2,outer child2child)
outer (child3,outer child3child)
outer (child4,outer child4child)
outer (child5,outer child5child)
WHERE ... appropriate joins
What would be in each row and how would I distinguish them?
Thanks!!