[SOLVED] JOIN if NOT in another table

[jaymc]

I have 2 tables and each of those tables are linked by an ID which is the same in both tables

 

1: g_images (id=id)

2: g_rates (id=Gid)

 

I want to select a random row from g_images where the id DOES NOT exist in g_rates

 

Dont worry about the random bit, I need to know how to do a reverse kind of INNER JOIN so it will only pull a row from g_images if there is no adjacent ID in g_rates

[fenway]

You mean like this?

 

select i.* 
from g_images as i 
left join g_rates as r on (r.Gid = i.id)
where r.Gid is null

[jaymc]

Yes, Great