sql - 为“aa”多次指定了“PATIENT_ID”列

Question

我正在尝试使用查询创建一个表。但即使我为列指定了确切的别名，我也会收到错误消息。

SELECT
    * 
INTO
    call_drug 
FROM
    (SELECT
         P.PATIENT_ID, O.PATIENT_ID, P.MRNO,
         O.MRNO, P.OLDMRNO, P.PATIENTNAME, P.DOB, 
         P.REGISTRATIONDATE AS FIRSTVISITDATE,
         P.AGE, P.GENDERID, DO.NOOFDAYS, DO.QUANTITY,
         DO.EFFECTIVEDATE, DO.TOTAL, STARTDATE,
         O.ORDEREDDATE, DO.ENDDATE, DO.PHARAMACYORDERTYPE,
         DO.PRESCRIPTION_TYPE, DO.INSTRUCTION, DO.ACTIVE_DRUG_NAME,
         DO.ACTIVE_DRUG, DG.DRUG_GEN_NAME
     FROM
         HINAI_PATIENT P,
         HINAI_ORDERS O, 
         hinai_drugorder DO, 
         hinai_DRUGGENERICS DG,
         HINAI_GENERICDRUGMAPPING GM
     WHERE   
         P.MRNO = O.MRNO
         AND P.PATIENT_ID = O.PATIENT_ID
         AND O.ORDER_ID = DO.ORDERS_ID
         AND DO.DRUGID = GM.ITEMGENERICID
         AND DO.DRUGFORM = GM.DRUGFORM
         AND DG.DRUG_GEN_ID = GM.DRUGGENERICS
         AND DO.PHARAMACYORDERTYPE = 'PRESCRIPTION') aa

提前致谢！

标签： sql