Am Donnerstag, den 05.06.2008, 17:14 +0300 schrieb Amihay Gonen: > select 1 from dual where NUMTAB(9,8,4) in NUMTAB(4,8,9,33) ; select distinct 1 from dual where NUMTAB(9,8,4) in NUMTAB(4,8,9,33) ; hth Jörg Jost -- //www.freelists.org/webpage/oracle-l