Need Some Help

[Rayn]

Alright I cant seem to get this. I have two tables in my database. This is what they contain
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 code but I dont get any results.

  $grid=mysql_query("SELECT * FROM first LEFT JOIN second ON first.id=second.id WHERE userskills.userid<>1 ORDER BY skills.title ASC");
  if (mysql_num_rows($grid)) {

do {

   // code here

} while ($gridinfo=mysql_fetch_array($grid));

  }

thanks for your time
- Rayn

[sarahk]

I'm not too hot on the left join type of terminology but how about

select id, title from first
where id not in (select id from second)

or

select id, title from first
where not exists (select 1 from second where first.id = second.id)