問題詳情
29.當用 SQL 查詢兩表格 A 與 B，哪個查詢方式會將條件的空值(Null)去除？
(A) SELECT * FROM A INNER JOIN B ON A.id = [B]id
(B) SELECT * FROM A LEFT JOIN B ON A.id = [B]id
(C) SELECT * FROM A RIGHT JOIN B ON A.id = [B]id
(D) SELECT * FROM A, B
參考答案
答案：A
難度：非常簡單1
統計：A(4),B(0),C(0),D(0),E(0)