代码如下:
select b.ryxx ,b.rybh ,b.bmmc ,a.* from lssj a inner join ryxx b on a.ryid=b.ryid where (xffs='正常消费' or xffs='因错退还' of xffs='餐费补扣')and xfsj between '2006-12-01' and '2006-12-31 23:59:59' and 1=1 and (a.ryid = (select ryid from ryxx where rfkh='00001') or a.ryid = (select ryid from ryxx where rybh='00001')or a.ryid=(select ryid from ryxx where ryxm = '00001')) order by xfsj desc
这个是要查找卡号是00001的人的消费记录