Hi,
I see that we deal with the situation where we need to do a basic join
from a table more than once this:
e.g. select a.*, b.*, c.*
from a left join b on ... left join c on ...;
But it is not obvious whether or not we provide the ability to specify
additional criteria against the table we are joining to thus:
e.g. select a.*, b.*, *.c
from a left join b on a.a_id = b.a_id and b.active = 'Y'
left join c on ...;
Is this currently possible and if so, which criterion would I need to
grab in order to do it?
Thanks,
Scott
--
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
