CATEGORIES
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.
Most Popular Articles
- How can I run my Stored Procedure in SQL Server 2005
- SQL Join Query for Microsoft Access Database
- What is the use of nolock condition in SQL Query
- How can I Truncate my Database Log to Reduce the Size
- when to use cast and when to use convert operator in SQL
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.