子查询改成连接查询
Select * FROM {客户} as a left join (Select 客户ID FROM {订单} WHERE 订购日期 <= #1998-5-1#) as b on a.客户id=b.客户id WHERE b.客户ID is not null
加好友 
发短信
Post By：2017/8/13 14:22:00 [显示全部帖子]
