两张表:server_synchro_info ,##realtimedata,两张表都有设备编号clientSerial
select * from server_synchro_info where (customID='200023') and
server_synchro_info.clientserial not in(select ##realtimedata.clientserial from ##realtimedata where defaultTag2='200023')
在一张表中,而不在另一张表中的记录
最新推荐文章于 2022-04-19 16:27:57 发布