> BTW, the other posted "cleaner" model doesn't work for me.  If there is NO
> row in the subtable that matches, the other version returns nothing (which
> makes sense since the initial select fails to match any rows as one of the
> things its trying to match is missing.)

Ah, wasn't thinking of that case.    Problem with not really knowing what the 
database is about.

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to