[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