Dave:
Thanks! That works great.
Guang
-Original Message-
Dave Hau
Sent: Wednesday, August 27, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
select distinct n.cognateid, m.isirefid,4, linkdate
from mt.externallink l, refidmatch m, nametag n
where l.objectid = n.geneid
and
select distinct n.cognateid, m.isirefid,4, linkdate
from mt.externallink l, refidmatch m, nametag n
where l.objectid = n.geneid
and m.pubmedid = l.identifier
and externaldbid = 9
and l.identifier in
(select identifier from mt.externallink
where externaldbid = 9
group by identifier
having