[thelist] SQL: Eliminating Duplicates with .getRows()
rudy
r937 at interlog.com
Mon Sep 2 22:34:00 CDT 2002
oops, didn't notice the aApp in the select list, the second select has to
have a join as well
select sID, sNumber, sTitle, sOshaAnsi, aApp
from xrefAppsSigns
inner
join tblSigns
on aNumber = sNumber
where aApp LIKE '% s %'
union
select sID, sNumber, sTitle, sOshaAnsi, aApp
from tblSigns
inner
join xrefAppsSigns
on sNumber = aNumber
where sTitle LIKE '% s %'
rudy
More information about the thelist
mailing list