下列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’)

答案:登入後查看
統計: A(40), B(49), C(27), D(11), E(0) #342387

詳解 (共 1 筆)

#771640

why ?

 

0
1