[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.


More information about the thelist mailing list