Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Comparison between inner join and normal		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ngaisteve1
Junior Member

Malaysia
241 Posts
Posted - 24 September 2003 :  00:06:43  Show Profile  Send ngaisteve1 an ICQ Message
I just would like to know the difference between this two type of sql query

1. SELECT [Last Name], InvoiceDate, Amount
FROM tblCustomers INNER JOIN tblInvoices
ON tblCustomers.CustomerID=tblInvoices.CustomerID
ORDER BY InvoiceDate

2. SELECT [Last Name], InvoiceDate, Amount
FROM tblCustomers, tblInvoices WHERE
tblCustomers.CustomerID=tblInvoices.CustomerID
ORDER BY InvoiceDate

Thank you.

Doug G
Support Moderator

USA
6493 Posts
Posted - 24 September 2003 :  13:58:12  Show Profile
I don't think there is any significant difference. Possibly the optimizer will give a performance advantage with one form over the other.
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts
Posted - 24 September 2003 :  16:42:55  Show Profile
I'd agree with Doug. Access seems to prefer method 1, but when I'm writing the select I would always use method 2 - my brain processes that better for some reason
Go to Top of Page

ngaisteve1
Junior Member

Malaysia
241 Posts
Posted - 25 September 2003 :  00:22:41  Show Profile  Send ngaisteve1 an ICQ Message
They said the first one more readable, can see which one join with which one.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07