[thelist] Access SQL Join and WHERE Clauses

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


http://www.adopenstatic.com/faq/80040e10.asp

Cheers
Ken

: -----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