[thelist] SQL: Eliminating Duplicates with .getRows()
Ken Kogler
ken.kogler at curf.edu
Mon Sep 2 22:42:01 CDT 2002
> okay, try this -- [snip]
SQL looks like a work of art, Rudy, but it appears as if Access doesn't
support the join... Is there another way to do it? In my original post,
I had something to the effect of:
select * from tblOne, tblTwo
...which is how Access handles joins (I think).
> did you want those spaces in the search strings?
Yup... It's actually supposed to read:
...LIKE '%" & s & "%'...
Which is the ASP way to pop a value in between the '% and the %'.
More information about the thelist
mailing list