SQL Syntax error

[gm_lowery]

Hi everyone,

I am basically new to SQL. I have been asked to create an archiving query which is something that I have never done before. I have two queries which I need to join to create one query. Basically I want to have them sorted by session id which is common amongst the two tables. I'm not really sure how to join them however. Here is a screenshot.

Like I said I am new to this. So if you need me to clarify something please ask.



Thanks,

Michael.

[JoeM]

I'm not really sure how to join them however.

Just drag and drop the Session ID field from one table on to the other.
See here for more details: http://www.about-access-databases.co...-database.html