[thelist] SQL: Eliminating Duplicates with .getRows()
rudy
r937 at interlog.com
Mon Sep 2 23:10:01 CDT 2002
> 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
More information about the thelist
mailing list