Selecting multiple tables in access

[Anon]

Hello,

I'm having some difficulty selecting multiple tables in my asp code. What I want to do is pull data from two tables and have the results displayed. However, when I attempted to do this I receive the following:

[Microsoft][ODBC Microsoft Access 97 Driver] The specified field 'Description' could refer to more than one table listed in the FROM clause of your SQL statement.

/cgi-bin/query_pubs3.asp, line 7

My SQL Select statement is as follows:

=========

SQL = "Select FROM tbPublications, Sub WHERE Description like '" & ("%") & request("Description") & ("%") &"' AND Author like '" & ("%") & request("Author") & ("%") &"' AND Date like '" & ("%") & request("Date") & ("%") &"' AND Title like '" & ("%") & request("Title") & ("%") &"' ORDER BY Title"

BTW -> it's querying the page prior and displaying the results (it's a simple access search engine...). Both fields within the each table are identicle. How can I get around this?

Any help would be MOST appreciative!! 🙂
BTW - If you could send your response with a cc: to my email ([e-mail]), that would be g8 (just in case).

Thank again!
- Dave

[Anon]

Fancy that, asking an sql question related to asp, on php forum.

Anyway, brush up on your SQL, read something about the JOIN statement.
You have to tell your sql server where in which table the fields are!

[Anon]

The solution is simple... just put the tablename in front of your fieldnames like this: tbPublications.Author or othertable_name.fieldname