29 Ocak 2015 Perşembe

Sql Join Tipleri

Sql Join tiplerinin kullanımları aşağıdaki gibidir.



    [ { INNER | { { LEFT | RIGHT | FULL } [ OUTER ] } } [ <join_hint> ] ]
    JOIN

SELECT *
FROM A JOIN B ON A.X = B.Y

A LEFT JOIN B            A LEFT OUTER JOIN B
A RIGHT JOIN B           A RIGHT OUTER JOIN B
A FULL JOIN B            A FULL OUTER JOIN B
A INNER JOIN B           A JOIN B



enter image description here
Share:

0 yorum:

Yorum Gönder