Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL (DQL (Data Query Language) (Select (GROUP BY (Sem GROUP BY (COUNT(),…
SQL
-
-
-
-
-
JOIN
OUTER JOIN
RIGHT OUTER JOIN
SELECT coluna1,coluna2... FROM tabela1 RIGHT OUTER JOIN tabela2 ON(tabela1.coluna1 = tabela2.coluna2)
LEFT OUTER JOIN
SELECT coluna1,coluna2... FROM tabela1 LEFT OUTER JOIN tabela2 ON(tabela1.coluna1 = tabela2.coluna2)
INNER/SELF JOIN
SELECT coluna1,coluna2... FROM tabela INNER JOIN coluna ON(valor1.valor2 = valor3)