[thelist] SQL: Eliminating Duplicates with .getRows()

rudy thelist at lists.evolt.org
Mon Sep 2 22:34:00 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