Présentation 19 -
SQL : requêtes croisées de base
ALIAS SQL
Syntaxe pour une colonne
SELECT column_name AS alias_name
FROM table_name;ALIAS SQL
Syntaxe pour une table
SELECT column_name(s)
FROM table_name AS alias_name;INNER JOIN
jointure interne
SELECT column_name(s)
FROM table1
INNER JOIN table2 ON table1.column_name = table2.column_name;
LEFT JOIN
jointure externe
SELECT column_name(s)
FROM table1
LEFT JOIN table2 ON table1.column_name = table2.column_name;
RIGHT JOIN
jointure externe
SELECT column_name(s)
FROM table1
RIGHT JOIN table2 ON table1.column_name = table2.column_name;