Queries Using Multiple Tables can incorporate fields from two different tables We can then combine them by using an inner join between the tables or use the simple where clause.
Using the inner join
SELECT [Customers].[Company Name], [Orders].[Employee ID]
FROM [Customers] INNER JOIN [Orders]
ON [Customers].[Customer ID] = [Orders].[Customer ID]
Using the where clause
SELECT [Customers].[Company Name], [Orders].[Employee ID]
FROM [Customers], [Orders]
WHERE [Customers].[Customer ID] = [Orders].[Customer ID]
I just had a doubt in mind which of these queries would run in a faster and optimized way. I am using SQL server 2000
Thanks!
Prasad