hdc person temporary

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