informatique:databases:join_representation
Différences
Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentesRévision précédente | |||
informatique:databases:join_representation [2021/02/22 03:55] – ↷ Page déplacée de informatique:mysql:join_representation à informatique:databases:join_representation alexis | informatique:databases:join_representation [2022/09/22 19:10] (Version actuelle) – alexis | ||
---|---|---|---|
Ligne 16: | Ligne 16: | ||
</ | </ | ||
<WRAP half column> | <WRAP half column> | ||
+ | <WRAP prewrap> | ||
<code sql> | <code sql> | ||
SELECT < | SELECT < | ||
Ligne 22: | Ligne 23: | ||
ON A.Key = B.Key | ON A.Key = B.Key | ||
</ | </ | ||
+ | </ | ||
</ | </ | ||
</ | </ | ||
Ligne 39: | Ligne 41: | ||
</ | </ | ||
<WRAP half column> | <WRAP half column> | ||
+ | <WRAP prewrap> | ||
<code sql> | <code sql> | ||
SELECT < | SELECT < | ||
Ligne 45: | Ligne 48: | ||
ON A.Key = B.Key | ON A.Key = B.Key | ||
</ | </ | ||
+ | </ | ||
</ | </ | ||
</ | </ | ||
Ligne 62: | Ligne 66: | ||
</ | </ | ||
<WRAP half column> | <WRAP half column> | ||
+ | <WRAP prewrap> | ||
<code sql> | <code sql> | ||
SELECT < | SELECT < | ||
Ligne 68: | Ligne 73: | ||
ON A.Key = B.Key | ON A.Key = B.Key | ||
</ | </ | ||
+ | </ | ||
</ | </ | ||
</ | </ | ||
Ligne 85: | Ligne 91: | ||
</ | </ | ||
<WRAP half column> | <WRAP half column> | ||
+ | <WRAP prewrap> | ||
<code sql> | <code sql> | ||
SELECT < | SELECT < | ||
Ligne 91: | Ligne 98: | ||
ON A.Key = B.Key | ON A.Key = B.Key | ||
</ | </ | ||
+ | </ | ||
</ | </ | ||
</ | </ | ||
Ligne 107: | Ligne 115: | ||
</ | </ | ||
<WRAP half column> | <WRAP half column> | ||
+ | <WRAP prewrap> | ||
<code sql> | <code sql> | ||
SELECT < | SELECT < | ||
Ligne 114: | Ligne 123: | ||
WHERE B.Key IS NULL | WHERE B.Key IS NULL | ||
</ | </ | ||
+ | </ | ||
</ | </ | ||
</ | </ | ||
Ligne 130: | Ligne 140: | ||
</ | </ | ||
<WRAP half column> | <WRAP half column> | ||
+ | <WRAP prewrap> | ||
<code sql> | <code sql> | ||
SELECT < | SELECT < | ||
Ligne 137: | Ligne 148: | ||
WHERE A.Key IS NULL | WHERE A.Key IS NULL | ||
</ | </ | ||
+ | </ | ||
</ | </ | ||
</ | </ | ||
Ligne 153: | Ligne 165: | ||
</ | </ | ||
<WRAP half column> | <WRAP half column> | ||
+ | <WRAP prewrap> | ||
<code sql> | <code sql> | ||
SELECT < | SELECT < | ||
Ligne 160: | Ligne 173: | ||
WHERE A.Key IS NULL OR B.Key IS NULL | WHERE A.Key IS NULL OR B.Key IS NULL | ||
</ | </ | ||
+ | </ | ||
</ | </ | ||
</ | </ |
informatique/databases/join_representation.1613994935.txt.gz · Dernière modification : 2021/02/22 03:55 de alexis