lto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 12:06 AM
To: CF-Talk
Subject: OT: angry query with sharp teeth : avoid!!!
First thanks again to those that helped me yesterday with a similar query. I
figured out how to run this query on a table of messages, also pulling from
the users t
Access syntax is pretty funky. The easiest thing I've always found is to
open the access database and use the native query builder to create your
joins. When you're using multiple tables, you need to nest your joins.
Take a look at this example from a query I did:
FROM (party INNER JOIN (race IN
First thanks again to those that helped me yesterday with a similar query. I
figured out how to run this query on a table of messages, also pulling from
the users table where appropriate. (for an Access DB by the way, query
pasted below for reference) ... (The secret was a LEFT JOIN!)
===
3 matches
Mail list logo
