1 關聯式資料庫(relational database)中有兩個表格為 students 和 takes,這兩個表格只共用屬性 id,當
要用此屬性連接兩個表格時,只要取出兩個表格皆出現的資料列(tuple),則應該使用下列那個 SQL
指令(根據 ISO 頒布的 SQL 標準語法)?
(A)SELECT * FROM students NATURAL INNER JOIN takes;
(B)SELECT * FROM students LEFT OUTER JOIN takes USING (id);
(C)SELECT * FROM students RIGHT OUTER JOIN takes ON students.id = takes.id;
(D)SELECT * FROM students NATURAL FULL OUTER JOIN takes;