db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael.Kashamb...@bmwna.com
Subject RE: Subqueries in Torque
Date Thu, 24 Jun 2004 15:23:15 GMT
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: Michael.Kashambuzi@bmwna.com [mailto:Michael.Kashambuzi@bmwna.com]
Sent: Tuesday, June 22, 2004 7:33 PM
To: torque-user@db.apache.org
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

---------------------------------------------------------------------
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