1.select applydate from cardapply cleft join cardapplydetail cd on c.applyno=cd.aaplynowhere idcard = '1234567812342'2.select count(*),idcardfrom cardapply cleft join cardapplydetail cd on c.applyno=cd.aaplynowhere idcard in (select idcard from cardapplydetail where (select count(idcard) from cardapplydetail group by...
