[thelist] Access SQL Join and WHERE Clauses

[Adrian Gonzales]

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-