Hi there,

I have stuck with my sql select which thrown the error of "column ambiguously defined".
I am currently using oracle.

Here's the code:

Code:
SELECT T_LC_TYPE.*, T_LC_CONDITION.DESCRIPTION_EN AS COND_DESCPT_EN, T_LC_CONDITION.DESCRIPTION_BM AS COND_DESCPT_BM, T_LC_DOC.DESCRIPTION_EN AS DOC_DESCPT_EN, 
T_LC_DOC.DESCRIPTION_BM AS DOC_DESCPT_BM, T_REF_FREQUENCY.DESCRIPTION_EN AS FRE_DESCPT_EN, T_REF_FREQUENCY.DESCRIPTION_BM AS FRE_DESCPT_BM, 
T_USER_DEPARTMENT.DESCRIPTION_EN AS DEPT_DESCPT_EN, T_USER_DEPARTMENT.DESCRIPTION_BM AS DEPT_DESCPT_BM FROM T_LC_TYPE, T_LC_CONDITION, T_LC_DOC, T_LC_COMMENTER, T_REF_FREQUENCY, 
T_USER_DEPARTMENT 
WHERE T_LC_TYPE.OBJECTID = '013C1DF933F56BA2' 
AND T_LC_CONDITION.TYPE_OBJECTID = T_LC_TYPE.OBJECTID
AND T_LC_DOC.TYPE_OBJECTID = T_LC_TYPE.OBJECTID
AND T_LC_COMMENTER.USER_DEPARTMENT_OBJECTID = T_USER_DEPARTMENT.OBJECTID 
AND T_LC_TYPE.FREQUENCY_OBJECTID = T_REF_FREQUENCY.OBJECTID 
AND T_LC_TYPE.LICENSE_ISSUED_BY = T_USER_DEPARTMENT.OBJECTID 
AND REQUEST_STATUS = 'APPROVED'
I stuck with this couple of hours and did not see the problem. Please advise.
Thanks in advance.