You should post to the torque-user mailing list, they have the most activity and support there...
ERic > -----Original Message----- > From: Chris Joelly [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 26, 2004 5:40 PM > To: [EMAIL PROTECTED] > Subject: Torque, building Criteria for query ... > > > Hello! > > i'm trying to build a criteria for the following selects: > > i hava a table from which i want to read a column: > > select distinct col1 from table1 where col2 = 'value1' > > then i want to use the list with the values 'col1' in another select > statement: > > select * from table2 where col1 not in ('values from table1.col1 read > with previous select') > > are there a simple way to use Criteria for this task? > > thx, Chris > > -- > mit freundlichen Gr��en / with kind regards > > Ing. Christian J�lly @ Solutions > unycom Information Technology Services GmbH > A-8042 Graz | Schmiedlstra�e 1 / III > > Tel: ++43 (0)316 / 818 828 - 30 > Fax: ++43 (0)316 / 818 828 - 38 > [EMAIL PROTECTED] > http://www.unycom.com > > Die besten Dinge verdanken wir dem Zufall. > -- Giacomo Girolamo Casanova > > > --------------------------------------------------------------------- > 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]
