2.8 C | 11.1 km/h 135 SE | 1025 mb (30.27 inHg) Constantă
INNER JOIN
|
1 2 3 |
SELECT <fields> FROM A INNER JOIN B ON (A.key = B.key) |
LEFT JOIN
|
1 2 3 |
SELECT <fields> FROM A LEFT JOIN B ON (A.key = B.key) |
RIGHT JOIN
|
1 2 3 |
SELECT <fields> FROM A RIGHT JOIN B ON (A.key = B.key) |
OUTER JOIN
|
1 2 3 |
SELECT <fields> FROM A FULL OUTER JOIN B ON (A.key = B.key) |
LEFT ONLY JOIN
|
1 2 3 4 |
SELECT <fields> FROM A LEFT JOIN B ON (A.key = B.key) WHERE B.key IS NULL |
RIGHT ONLY JOIN
|
1 2 3 4 |
SELECT <fields> FROM A RIGHT JOIN B ON (A.key = B.key) WHERE A.key IS NULL |
LEFT ONLY AND RIGHT ONLY JOIN
|
1 2 3 4 |
SELECT <fields> FROM A RIGHT JOIN B ON (A.key = B.key) WHERE A.key IS NULL AND B.key IS NULL |
Try Dropbox