db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael.Kashamb...@bmwna.com
Subject Subqueries in Torque
Date Tue, 22 Jun 2004 23:33:04 GMT
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


Mime
View raw message