creat view V_PERMIT
as
SELECT PERMIT.PERMITID, PERMIT.ITEMID, PERMIT.COMPANYCODE, PERMIT.PERMITNO, PERMIT.LOCATION,
PERMIT.BUILDAREA, PERMIT.PERMITAREA, PERMIT.SELLTYPE, PERMIT.NUMS, PERMIT.FLOORS, PERMIT.BUILDNO,
PERMIT.SETS, PERMIT.OUTAREA, PERMIT.OUTNUMS, PERMIT.OUTBUILDNO, PERMIT.OUTSETS, PERMIT.OUTNO,
PERMIT.INAREA, PERMIT.INNUMS, PERMIT.INBUILDNO, PERMIT.INSETS, PERMIT.PRICE, PERMIT.GIVEDATE,
PERMIT.STRUCTURE, PERMIT.[USE], PERMIT.STRUC1, PERMIT.STRUC2, PERMIT.STRUC3, PERMIT.STRUC4,
PERMIT.STRUC5, PERMIT.USE1, PERMIT.USE2, PERMIT.USE3, PERMIT.USE4, PERMIT.USE5, PERMIT.USE6,
PERMIT.USE7, PERMIT.USE8, PERMIT.OPENDATE, PERMIT.BUILDDATE, PERMIT.AGENTNAME, PERMIT.APPLYDATE,
PERMIT.CONSTRUCTUNIT, PERMIT.AGENTUNIT, PERMIT.REMARK, PERMIT.CONFIRMED, PERMIT.LOGINID,
PERMIT.NETWORKAREA, PERMIT.NETWORKSETS, PERMIT.CONSTRUCTNO, PERMIT.SELLTEL, PERMIT.SCALENO,
PERMIT.HOUSELOGID, PERMIT.LANDNO, PERMIT.CHECKFLAG, PERMIT.CHECKDATE, PERMIT.COMMITFLAG,
PERMIT.ALLFLOORS, PERMIT.ADDTJDATE, ITEM.DISTRICT,
ITEM.ITEM, COMPANY.COMPANYCODE AS
