How can I re-state this SQL statement without JOIN?

SELECT Document.DocumentID, Document.DocumentName,
FROM UserProject, (Document INNER JOIN ProjectDocument ON Document.DocumentID = ProjectDocument.DocumentID) INNER JOIN Project ON ProjectDocument.ProjectID = Project.ProjectID
WHERE (((UserProject.UserID)=1));

Thank you,

I'm not sure about the () around the tables and joins in the from clause, but this is basically how you do it. You just need to put all your tables in the FROM with commas separating them, then put the join criteria in the WHERE clause.

SELECT doc.DocumentID, doc.DocumentName,
FROM UserProject AS up, Document, ProjectDocument AS pd, Project AS p
WHERE doc.DocumentID = pd.DocumentID
AND pd.ProjectID = p.ProjectID
AND up.UserID=1;

or something like that. Again, the () from (Document to .DocumentID) don't quite make sense but you should be able to get the general idea.

Peter
------------------------------------------------------
Work smarter, not harder.

There is an error in the code that Peter posted, it is missing the AS doc so the statement won't run. If you do not alias a table then you must reference the column by using the full table name. The SQL statement should read:
   Just a typo I am sure but I though it best to correct for clarity.

Regards
Owain Williams

Of course, placing the JOIN criteria in the WHERE clause simply removes the keyword 'JOIN' from the query; it's still doing the relational INNER JOIN operation (using "old-style" syntax).

To truly formulate the query without a JOIN at all would require correlated subqueries. But why would anyone want to do that, unless it were a homework assignment? ;)

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thank you, all. It works now.