Inner Join vs Cartesian Product?

List:

I've a query works correctly on my test dataset written one of two ways:

' All the AccountAccess records that have a matching user over here
SELECT AccountAccess.* FROM AccountAccess, [User List] WHERE
AccountAccess.User = [User List].[User Key]

SELECT AccountAccess.* FROM AccountAccess INNER JOIN [User List] ON
AccountAccess.User = [User List].[User Key]

Which is preferable? Why?

Thanx


Charles

"U-CDK_CHARLES\Charles" <"Charles Krug"@cdksystems.com> wrote in
message news:O02m4ZaSEHA.1448@TK2MSFTNGP09.phx.gbl
 > List:
 >
 > I've a query works correctly on my test dataset written one of two
 > ways:
 >
 > ' All the AccountAccess records that have a matching user over here
 > SELECT AccountAccess.* FROM AccountAccess, [User List] WHERE
 > AccountAccess.User = [User List].[User Key]
 >
 > SELECT AccountAccess.* FROM AccountAccess INNER JOIN [User List] ON
 > AccountAccess.User = [User List].[User Key]
 >
 > Which is preferable? Why?

IMO the second separates the join specifications from the where conditions
and is much easier to work with.

--
Reply to the group so all can participate
VB.Net... just say "No"<!-- ~MESSAGE_AFTER~ -->