Re: Can't get my query right!!
From: Sander Smit <Sander.Smit_at_cmg.nl>
Date: 1997/08/12
Message-ID: <01bca705$4c7d81e0$6506130a_at_arjans.att.cmg.nl>#1/1
Date: 1997/08/12
Message-ID: <01bca705$4c7d81e0$6506130a_at_arjans.att.cmg.nl>#1/1
You could do something like this:
select tab1.name,tab1.key,tab2.key,tab2.address
from tab1 tab1, tab2 tab2, tab2 tab2copy
where tab1.key = tab2.key
and tab2.address = (select min(address) from tab2copy.key where
tab2copy.key= tab2.key)
Sander Smit Received on Tue Aug 12 1997 - 00:00:00 CEST