SQL操作應用——兩張關聯(lián)表,刪除主表中已經(jīng)在副表中沒有的信息
提問人:ylm發(fā)布時間:2020-09-28
SQL:
delete from info where not exists ( select * from infobz where info.infid=infobz.infid )
繼續(xù)查找其他問題的答案?
相關視頻回答
SQL:
delete from info where not exists ( select * from infobz where info.infid=infobz.infid )
點擊加載更多評論>>