試題詳解

下列SQL程式碼，何者為join的應用
(A)select stuid,stuname from stutable join to scotable where stutable.stuid=scotable.stuid
(B)select stutable.stuname,scotable.mathscore from stutable,scotable where stutable.stuid=scotable.stuid
(C)select stutable.stuname,score.mathscore where stutable.stuid=scotable.stuidinsert into stutable(stuid,stuname) values(123,’peter’)