|
-
try this
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
WHERE FUNCTIONS.FUN_ID = 'F20031235'
and
FUNCTIONS.FUN_ID = EQUIPMENTS_FUNCTIONS.FUN_ID
and
EQUIPMENTS_ID.EQUIP_ID = EQUIPMENTS.EQUIP_ID
and
FUNCTIONS.FUN_ID = FUNCTIONS_HIRE_EQUIPMENTS.FUN_ID
and
FUNCTIONS.FUN_ID = FUNCTIONS_STAFFS.FUN_ID
and
FUNCTIONS_STAFFS.EMP_ID = STAFFS.EMP_ID
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|