RE: Subqueries in Torque

[Michael . Kashambuzi]

Basically what I am trying to do is avoiding listing all teh columns in the
select clause a a result of needing to add a group by clause.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 7:33 PM
To: [EMAIL PROTECTED]
Subject: Subqueries in Torque


Hi-

I have searched the archives and have not been able to find a solution to a
problem I have.

Is anyone familiar with how to produce a subquery in Torque 3.1?

I am trying to achieve the following:

        select *
        from table1 as a
        where a.col1 in
        (
                select *
                from table2 as b
                where b.col1 = 'SOME KNOWN VALUE'
        )

Thanks.

Michael

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]