时间:2021-07-01 10:21:17 帮助过:3人阅读
开发实例:
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表已经存在的数据
标签: