db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Eade <se...@backstagetech.com.au>
Subject Additional join criteria
Date Mon, 12 Feb 2007 04:29:37 GMT

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?


Scott Eade
Backstage Technologies Pty. Ltd.

To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

View raw message