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(7), B(1), C(2), D(0), E(0) #1570997
統計: A(7), B(1), C(2), D(0), E(0) #1570997