CATEGORIES
Acer
AMD
Apache
Apple
ASP
Business Object
Compaq
Crystal Reports
CSS
Database
Dell
DOT NET
Fujitsu
Gateway
Google
HP
HTML
IBM
IIS
Intel
Java
Mainframe
Microsoft
Networking
Oracle
SAP
SEO
Sony
SQL Server
Testing
Tomcat
Toshiba
Ubuntu
Visual Basic
Web Hosting
Windows
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
- SQL Join Query for Microsoft Access Database
- SQL Query to Copy and Insert a Record from Same Table
- What is the use of nolock condition in SQL Query
- How can I run my Stored Procedure in SQL Server 2005
- How do I Design a Database Which can Easily Handle the 10 Levels of Categories
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.