当前位置:Gxlcms > 数据库问题 > sql筛选查询A表中B表已经存在的数据

sql筛选查询A表中B表已经存在的数据

时间:2021-07-01 10:21:17 帮助过:3人阅读


FROM A LEFT OUTER JOIN
B ON A.ID = B.ID
WHERE B.ID IS NULL

 

开发实例:

SELECT Position_Car.Area, Position_Car.CarMapNum, Position_Car.CheweiID, Position_Car.CarlotName,
Position_Car.Points
FROM Position_Car LEFT OUTER JOIN
TRelation_Equipment_Position ON TRelation_Equipment_Position.CheWeiID = Position_Car.CheweiID
WHERE (Position_Car.CarMapNum = @CarMapNum) AND (TRelation_Equipment_Position.CheWeiID IS NULL)

sql筛选查询A表中B表已经存在的数据

标签:

人气教程排行