[thelist] Access SQL Join and WHERE Clauses
Adrian Gonzales
virexmachina at gmail.com
Sat Mar 12 02:28:06 CST 2005
I'm usually developing with MySQL, but now I've got to do something on
Access. My problem is I cant get a JOIN and a WHERE clause to work in
the same statement.
Heres my query:
FROM contacts
LEFT JOIN points ON contacts.cid = points.powner
WHERE contacts.fname LIKE '%#arguments.search#%';
And that throws the error: Too few parameters. Expected 1.
What am I doing wrong. I'm sure I'm just being stupid.
Thanks in advance.
--
-adrian-
More information about the thelist
mailing list