Table Data

ข้อมูล select facreg,fac_code,fflag,fname,startdate,(select min(startdate) from app_tok_fac where facreg=fac.facreg) as start_tok,(select min(fac_code) from app_form_fac where facreg=fac.facreg and recv_type='07') as faccode_07,expdate from fac where factype='3' and fflag='0' and exists (select * from app_form_fac a where recv_type='07' and a.facreg=fac.facreg) order by factype desc,facreg