RSS feed

SQL Join Query for Microsoft Access Database

Published by: San (1/31/2008)

JAN 31 2008

I have some sql queries written for SQL Server 2000 but these join queries are not working on Access database, anyone here who can guide me to change the query syntax or advice the right one to write.

 

SQL Query to Copy and Insert a Record from Same Table >>

 

COMMENT

Name: Vivek

If you have sql queries from SQL Server then you might have to change it a little bit.

example
SQL Server: select p.name, pa.amount from product as p join payment as pa on p.id = pa.product_id where pa.id = 2008
Microsoft Access: select p.name, pa.amount from product as p inner join payment as pa on p.id = pa.product_id where pa.id = 2008

You will have to add inner before join.

*Name:
*Comment:
You can use HTML tags here.
*Code: Please enter the sum of 5+2