Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Developers List" <torque-dev@db.apache.org>
Received-SPF: pass (herse.apache.org: local policy)
Message-ID: <45CFED31.8000409@backstagetech.com.au>
Date: Mon, 12 Feb 2007 15:29:37 +1100
From: Scott Eade <seade@backstagetech.com.au>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
To: Apache Torque Developers List <torque-dev@db.apache.org>
Subject: Additional join criteria
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org