|
-
Nov 10th, 2004, 01:27 PM
#1
Thread Starter
Hyperactive Member
Access doesn't like this query
I have this query, but MS Access 2000 doesn't seem to like the second INNER JOIN, it tells me 'Synax, missing operator in query expression'
Is my query incorrect, or does Access not handle multiple joins? If so, how could I rewrite my query?
SELECT sms_contacts.ContactName + ',' + sms_outbox.Message
FROM sms_contacts
INNER JOIN sms_recipients ON sms_contacts.ContactID = sms_recipients.ContactID
INNER JOIN sms_outbox ON sms_recipients.smsID = sms_outbox.smsoutboxID
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|