db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Joelly <chris.joe...@unycom.com>
Subject Torque, building Criteria for query ...
Date Fri, 27 Feb 2004 08:37:25 GMT
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
chris.joelly@unycom.com
http://www.unycom.com

Die besten Dinge verdanken wir dem Zufall.
		-- Giacomo Girolamo Casanova


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