Inner Join results used in criteria of Outer Join Query

Sort of. =)

You can use a pushdown in an outer join, as long as you are not doing a self join.

You have to cheat and do all the join criteria yourself, though. Check this thread for a more detailed discussion:

If you need an assist, post the SQL that is being generated and I can try to point you in the right direction.

  • Ernie

eepjr24 :us: (BOB member since 2005-09-16)