[thelist] Access SQL Join and WHERE Clauses

Ken Schaefer Ken at adOpenStatic.com
Sat Mar 12 04:43:15 CST 2005



: -----Original Message-----
: From: thelist-bounces at lists.evolt.org [mailto:thelist-
: bounces at lists.evolt.org] On Behalf Of Adrian Gonzales
: Sent: Saturday, 12 March 2005 7:28 PM
: To: thelist at lists.evolt.org
: Subject: [thelist] Access SQL Join and WHERE Clauses
: 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