Member Avatar for lifeworks

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

  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.