I have two tables, one a list of contractors and the secound a sign out list for jobs. I need to be able to get a lit of contractors that have signed out a job which I thought I could use an INNER JOIN for, but then I also want a list of contractors who have not signed out a certain job. What could I use to do this. The last time I did anything with JOINS I remeber a similar problem and I thought I used OUTER JOIN but that could be just me trying to make things make sense and there is no OUTER JOIN on the w3schools tutorial I have been using for SQL so I am not sure if this is what I want. Any help would be apreciated.