Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL - Coggle Diagram
SQL
-
-
opérations sur table
-
INTERSECTION
-
SELECT att1, att2 FROM t1 INTERSECT SELECT att1, att2 FROM t2
DIFFERENCE
SELECT att1, att2 FROM t1 EXCEPT SELECT att1, att2 FROM t2
SELECT att1, att2 FROM t1 WHERE att1 NOT IN (SELECT att1 FROM t2)
JOIN
-
SELECT truc FROM t1 INNER JOIN t.2 ON t.colon=t2.colon
INNER JOIN t. ON t2.colon=t3.colon WHERE smg != (SELECT....)