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]
