Left Join?

[Rayn]

Alright I cant seem to get this. I have two tables in my database. This is what they contain.. theyhave more but this is what they generally need to work

first: id,title
second id,userid,title

Now I want to use a left join and be able to get all the titles from first that I dont already have in my second table.

I worked up this.. but I dont get any results.

SELECT * FROM first LEFT JOIN second ON first.id=second.id WHERE userskills.userid<>1 ORDER BY skills.title ASC

or would it be

SELECT * FROM first LEFT JOIN second ON first.id!=second.id ORDER BY skills.title ASC

Thanks for your time
- Dan

[tomhath]

The manual is your friend. Bookmark this page:

http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html

[csn]

SELECT *
FROM first
LEFT JOIN second
ON first.id=second.id
where second.id is NULL