27,579
社区成员
发帖
与我相关
我的任务
分享
fee_check_card = "select * from car_park_fee inner join
car_park_templist on car_park_fee.car_fee_nums = car_park_templist.temp_card_num where datediff(d,car_park_fee.car_fee_start,getdate())= 0 and car_park_fee.car_fee_nums = '" + card_id + "' and car_park_fee.car_fee_nums <> car_park_templist.temp_card_num";
select * from 记录表
where 记录表.fee_card_id not in
(select fee_tempcard_id from 临时卡表)