Geek Answers Handbook

Oracle style merges into SQL Server

Is there a way to do oracle styles in SQL Server?

select * from t1, t2 where t1.id = t2.id (+)

EDIT

Why is it preferable to use the types "left external join" and "internal join"? It’s easier for me to read an outdated form, especially if there are complex combinations of tables.

+2
source share
2 answers

Microsoft uses the ANSI ISO SQL standard. Mark Ritman has a good explanation of ANSI joining and why you should use them . However, SQL Server does not support the NATURAL JOIN syntax specified in this article and the ANSI standard. You may be familiar with the old Oracle syntax, but it is a standard and something you will find in other database products.

To answer your question, there is no way to perform Oracle style joins on SQL Server. Even the style styles *= and =* are outdated and are completely removed in the next version of the product.

+9
source 
 SELECT * FROM t1 LEFT OUTER JOIN t2 ON t1.id = t2.id

This AskTom article shows the syntax equivalents from (+) to (LEFT AND RIGHT) OUTER JOIN for Oracle, and SQL Server uses OUTER JOIN .

+4
source

More articles:


All Articles