[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