關聯式資料庫(relational database)中有兩個表格為 students 和 takes,這兩個表格只共用屬性 id,當要用此屬性連接兩個表格時,只要取出兩個表格皆出現的資料列(tuple),則應該使用下列那個SQL指令(根據 ISO 頒布的 SQL 標準語法)?

ASELECT * FROM students NATURAL INNER JOIN takes;正確答案
BSELECT * FROM students LEFT OUTER JOIN takes USING (id);
CSELECT * FROM students RIGHT OUTER JOIN takes ON students.id = takes.id;
DSELECT * FROM students NATURAL FULL OUTER JOIN takes;
答案與詳解
