Jump to content


This topic is now archived and is closed to further replies.


selecting records with join

Recommended Posts

I have 3 tables im working with


sab_merc (job table)






Users (user table)



-other misc info


onjob_sab (theis in the x-ref table in a many to many relationship)





select  from onjob_sab left join sab_merc on(onjob_sab.user_id = sab_merc.id) where (onjob_sab.user_id != '1')


what I get from this query is all the open jobs that user 1 is not part of.


Now since multiple people can can be on multiple jobs I get a query that repeats the jobs for each users on them

2     chris     sextreme69     AIM     Stryker_     http://www.kingsofchaos.com/stats.php?id=3012255     Elves     1     Gold     500000     0           11.13.05     1131940811     open     2     1
2     chris     sextreme69     AIM     Stryker_     http://www.kingsofchaos.com/stats.php?id=3012255     Elves     1     Gold     500000     0           11.13.05     1131940811     open     2     3
4     workwarnings     testee     MSN     Steeringwhell     http://www.kingsofchaos.com/stats.php?id=3009074     Elves     5     Gold     78552     0           11.15.05     1132116959     open     4     4
4     workwarnings     testee     MSN     Steeringwhell     http://www.kingsofchaos.com/stats.php?id=3009074     Elves     5     Gold     78552     0           11.15.05     1132116959     open     4     5


All I really want from this query is to fin all jobs that user 1 is not assiged too and them display them in a "while loop" using php.


So in the example you can see that there is really only 2 jobs available that user 1 is not assiged too, but they get repeated since there is already other users on those jobs.


Hope this makes sense


Thanks in advance,


Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.