join question - 3 tables -

[hugstable]

this query is working but it cannot be this simple... Pls check it out and see if anything is jumping out at you... I added the cmp_* data - expected it to blow up but it did not...

SELECT DISTINCT
`tbl_job`.`job_id`,
`tbl_job`.`usr_id`,
`tbl_job`.`job_nam`,
`tbl_job`.`job_typ`,
`tbl_job`.`job_des`,
`tbl_job`.`job_nts`,
`tbl_job`.`job_str_dte`,
`tbl_job`.`job_crt_tdt`,
`tbl_job`.`job_upd_tdt`,
`tbl_usr`.`usr_id`,
`tbl_usr`.`cmp_id`,
`tbl_cmp`.`cmp_id`,
`tbl_cmp`.`cmp_nam`,
`tbl_usr`.`usr_nam_fst`,
`tbl_usr`.`usr_nam_lst`
FROM
`tbl_cmp`,`tbl_job`
LEFT OUTER JOIN
tbl_usr
ON tbl_job.usr_id = tbl_usr.usr_id
WHERE
tbl_job.job_id='#job_id#'
AND
tbl_usr.cmp_id = tbl_cmp.cmp_id

 

[r937]

  from tbl_job
inner 
  join tbl_usr
    on tbl_usr.usr_id = tbl_job.usr_id
inner
  join tbl_cmp 
    on tbl_cmp.cmp_id = tbl_usr.cmp_id
 where tbl_job.job_id = '#job_id#'

you probably don't need DISTINCT

r937.com | rudy.ca

 

[hugstable]

thanks much - will adjust..

just started using joins - very shaky..

 

[PHV]

just started using joins
Have a look here:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886