Last Updated：2025/12/04

Dictionary quizzes to help you remember vocabulary

(databases) A join yielding a set of records for two tables, where all rows of the left table are enlisted with all rows of the right table, even if the join condition does not find any matching row on the left or on the right table.

音声機能が動作しない場合はこちらをご確認ください

See correct answer

full outer join

Edit Histories（0）

Source Word

full outer join

Noun

(databases) A join yielding a set of records for two tables, where all rows of the "left" table are enlisted with all rows of the "right" table, even if the join condition does not find any matching row on the "left" or on the "right" table.

Japanese Meaning

データベースにおいて、2つのテーブルを結合する操作。左側のテーブルと右側のテーブルのすべての行を結果に含め、結合条件に合致しない行についてはNULLなどの補完値を用いる。