Classic ASP Discussion - Comparison between inner join and normal

Print Page | Close Window

Comparison between inner join and normal

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=5929
Printed Date: 30 March 2026 at 11:40pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Comparison between inner join and normal

Posted By: ngaisteve1
Subject: Comparison between inner join and normal
Date Posted: 23 September 2003 at 9:52pm

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.

Replies:

Posted By: Flamewave
Date Posted: 24 September 2003 at 8:47am

http://www.w3schools.com/sql/sql_join.asp - http://www.w3schools.com/sql/sql_join.asp

-------------
- Flamewave

They say the grass is greener on the other side, but if you really think about it, the grass is greener on both sides.

Posted By: Bullschmidt
Date Posted: 24 September 2003 at 10:23pm

I believe the usual way would be to use an INNER JOIN or if tblInvoice might contain no records for a customer perhaps a LEFT JOIN would be even better so that the customer would still be shown.

-------------
J. Paul Schmidt, Freelance ASP Web Developer
www.Bullschmidt.com - www.Bullschmidt.com
Classic ASP Design Tips, ASP Web Database Sample (Freely Downloadable)