INNER JOIN differences from ACCESS

[Elliott3]

Hi,
I am changing over a database from Access to SQL Server and my SQL knowledge is still minimal... Are there any differences between an INNER JOIN in Access and SQL Server?

CES

 

[philhege]

Mainly syntactical. You don't need to use all of those nested JOIN clauses in SQL.

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....
-----------
A skeleton walks into a bar, and says "I'll have a beer and a mop.

 

[ESquared]

You can put an entire query in parentheses where Access would accept only a table or query name. It's called a derived table. Just use an alias.

And aliases can be in the form "Alias = Expression" and not just "Expression (AS) Alias"

SELECT *
   FROM Table A
      INNER JOIN (
         SELECT * FROM Table2 WHERE Conditions
      ) B ON A.Id = B.Id
   WHERE Conditions