1,.select a.G_applydate from g_cardapply a join g_cardapplydetail b on a.申请单号=b.申请单号 where b.G_idcard varchar = '610123123123132123';2.selectG_idcard ,count(*) as geshu from _cardapplydetail group by G_idcard;3.update a set a. G_state varchar = '07'from g_cardapply a join g_cardapplydetail b on a.申请单号=b.申请单号whe
1,select g_applydate from g_cardapply where g_applyno = (select g_applyno from g_cardapplydetail where g_idcard ='610123123123132123')2,select * from g_cardapplydetail where g_ap
1.select a.G_applydate from g_cardapply a,g_cardapplydetail b where a.G_applyno =b.G_applynoand b.G_idcard ='610123123123132123'2.select G_idcard ,count(G_idcard) from g_cardapp