question

Nani avatar image
Nani asked

problem with joins

Don't we have

  • Natural join,
  • join using(Col_name)
  • join on

statements in sequel server as we have them in oracle?

If so plz state the syntax.

Thanks in advance.

sql-server-2005t-sqljoins
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Nitin 3 avatar image
Nitin 3 answered

In sql server both join can work.

Join without on

select a.name,b.id from tbla aa a,tblb as b where a.id=b.id

Join with on select a.name,b.id from tbla aa a inner join tblb as b on a.id=b.id

try this both will work in any version of sql server 2000/2005/2008

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered

TSQL joins are covered well on BOL: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/9b9caa3d-e7d0-42e1-b60b-a5572142186c.htm

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rob Farley avatar image
Rob Farley answered

T-SQL doesn't support NATURAL JOIN at all, nor does it support USING(ColName). Sorry...

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.