Helllo Im trying to run a select from 5 different tables, depending on the key in the main one like this:
select JOB_ASS.JOB_ASS_ID, JOB_ASS.START_DATE, JOB_ASS.STOP_DATE, JOB_ASS.JOB_NAME, JOB_ASS.LOCATION, JOB_ASS.NOTE, JOB_ASS.ORDER_ID, JOB_ASS.CONTRACT_VALUE, USER.SURNAME, USER.FIRSTNAME, PROJECT.PROJECT_NUM, PROJECT.SUBMIT_DATE, COMITENT.NAME, INVESTOR.NAME from JOB_ASS left join PROJECT using(JOB_ASS.JOB_ASS_ID = PROJECT.JOB_ASS_ID) left join USER using(JOB_ASS.USER_ID = USER.USER_ID) left join INVESTOR using(JOB_ASS.INVESTOR_ID = INVESTOR.INVESTOR_ID) left join COMITENT using(JOB_ASS.COMITENT_ID = COMITENT.COMITENT_ID); I did try using only join and that didn't work, so some guy pointed me to this method. But it doesn't work!!! I'm a sort of a newbie to SQL and really don't know how to fix this (nor does my book help me I). Thanx, Luka Birsa --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php