-3

What is the alternative or syntax for Natural Join in SQL SERVER.

Mike G
  • 4,232
  • 9
  • 40
  • 66
Ahmad Murtaza
  • 105
  • 6
  • 1
    Use an inner join http://stackoverflow.com/questions/8696383/difference-between-natural-join-and-inner-join or maybe you're after [using](http://stackoverflow.com/questions/370268/whats-the-difference-between-using-and-on-in-table-joins) – xQbert Apr 29 '15 at 13:00
  • Don't do natural join when programming. If a column with same name later is added to one of the tables, the join will quit working as expected. – jarlh Apr 29 '15 at 13:01

1 Answers1

0

As far as I know there is no natural JOIN in Sql Server. Also check SQL Server - lack of NATURAL JOIN / x JOIN y USING(field)

Community
  • 1
  • 1
Rahul Tripathi
  • 168,305
  • 31
  • 280
  • 331
  • Sir, I know there is no Natural Join in SQL, That's way i am asking for alternative for natural join – Ahmad Murtaza Apr 29 '15 at 12:59
  • @AhmadMurtaza:- You can use Inner Join. But without getting your exact issue it is hard to say how you can use it. More importantly we would like to know what you are trying to achive? – Rahul Tripathi Apr 29 '15 at 13:02