Table Data

ข้อมูล select fac.facreg,dispfacreg,fac.factype,fac.prov as fac_prov,oname,add_own,o.moo,o.soi,o.road,o.prov,o.amp,o.tumbol,o.zipcode, o.last_user,o.last_update from owner o,fac where o.facreg=fac.facreg and factype in ('1','2','3') and fac.fflag<>'2' and not exists (select 1 from tumbol where o.prov=prov and o.amp=amp and o.tumbol=tumbol) order by factype desc,fac.prov