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.
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.
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
T-SQL doesn't support NATURAL JOIN
at all, nor does it support USING(ColName)
. Sorry...
No one has followed this question yet.