Hi everyone, I am trying to do a query with 7 different tables by using the inner joint. When I run it it sais
ERROR at line 15:
ORA-00905: missing keyword
Any ideas what it could be?
HTML Code:SELECT FUNCTIONS.FUN_NAME, FUNCTIONS.FUN_ID, FUNCTIONS.FUN_NAME, EQUIPMENTS_FUNCTIONS.EQUIP_DESCRIPTION, HIRE_EQUIPMENTS.HEQUIP_DESCRIPTION, STAFFS.EMP_TITTLE FROM FUNCTIONS,EQUIPMENTS_FUNCTIONS,FUNCTIONS_HIRE_EQUIPMENTS,FUNCTIONS_STAFFS INNER JOIN EQUIPMENTS_FUNCTIONS ON FUNCTIONS.FUN_ID = EQUIPMENTS_FUNCTIONS.FUN_ID JOIN INNER JOIN EQUIPMENTS_FUNCTIONS ON EQUIPMENTS_ID.EQUIP_ID = EQUIPMENTS.EQUIP_ID INNER JOIN FUNCTIONS_HIRE_EQUIPMENTS ON FUNCTIONS.FUN_ID = FUNCTIONS_HIRE_EQUIPMENTS.FUN_ID INNER JOIN FUNCTIONS_STAFFS ON FUNCTIONS.FUN_ID = FUNCTIONS_STAFFS.FUN_ID INNER JOIN STAFFS ON FUNCTIONS_STAFFS.EMP_ID = STAFFS.EMP_ID WHERE FUNCTIONS.FUN_ID = 'F20031235';




Reply With Quote
