Hi
Im pulling a list of users out of a user table and want to include photos, from the photo table, for each user. But not all users have a photo in the photo table...
If I left join 'photos' onto 'users' i only get users who have photos... is there another option to get all users, and any photos attached?
Thanks
lworks