CREATE TEMPORARY TABLE person
SELECT
person.HOSPCODE ,
person.CID ,
person.PID ,
person.HID ,
person.PRENAME ,
person.NAME ,
person.LNAME ,
person.HN ,
person.SEX ,
person.BIRTH ,
person.MSTATUS ,
person.OCCUPATION_OLD ,
person.OCCUPATION_NEW ,
person.RACE ,
person.NATION ,
person.RELIGION ,
person.EDUCATION ,
person.FSTATUS ,
person.FATHER ,
person.MOTHER ,
person.COUPLE ,
person.VSTATUS ,
person.MOVEIN ,
person.DISCHARGE ,
person.DDISCHARGE ,
person.ABOGROUP ,
person.RHGROUP ,
person.LABOR ,
person.PASSPORT ,
person.TYPEAREA ,
person.D_UPDATE ,
person.TELEPHONE ,
person.MOBILE ,
person.HDC_DATE
WHERE
person.HOSPCODE = '03301';
SELECT * FROM person;
