Subqueries in Torque

[Michael . Kashambuzi]

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]