Help with query Please

[doubledown]

ok i have 2 tables

a users table and a users_photos table

i have a select statement like this at the moment

select u.user_id,u.username,up.thumb from users as u, users_photos as up where u.user_id = up.user_id and up.is_approved = 1;

which selects all the users and their thumbnail as long as they have up.is_approved = 1 ..

I'd like to change this so that if is_approved doesnt = 1 or, they dont have an entry in users_photos, it just returns the text "no photo" or something as thumb..

Im not sure if this is possible with just one query,

Any help would be greatly appreciated

Thanks in advance

[csn]

Well, remove is_approved from the where clause. Sounds like a left join will work for the rest.

[doubledown]

Originally posted by csn
Well, remove is_approved from the where clause. Sounds like a left join will work for the rest.

switched it to use a left join, working now, thx.