Subqueries in Torque

[Mi...@bmwna.com]

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