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

[rudy]

> SQL looks like a work of art, Rudy,

you are too kind

>  but it appears as if Access doesn't support the join...
>  Is there another way to do it?

whoa, it works in access 97, i use it all the time -- that's the
new-fangled inner join syntax

okay, try the old way, it should still work (although i did see something
about microsoft eventually not supporting it, but maybe that was
sql/server...)

   select sID, sNumber, sTitle, sOshaAnsi, aApp
     from xrefAppsSigns
        , tblSigns
    where aNumber = sNumber
      and aApp LIKE '%s%'
   union
   select sID, sNumber, sTitle, sOshaAnsi, aApp
     from tblSigns
        , xrefAppsSigns
    where sNumber = aNumber
      and sTitle LIKE '%s%'

>> did you want those spaces in the search strings?
>
>Yup... It's actually supposed to read:
>
>  ...LIKE '%" & s & "%'...

ah, okay, then the spaces aren't actually part of the string
(see revised query)

rudy