Join question


I have the following SQL query. I’m trying to return all domains from the domains table along with the corresponding user information. At the moment, the query returns all domains, but is it possible to return users even if they have no domains listed in the domains table?

SELECT, dt_users.username, dt_users.email_address, dt_users.first_name, dt_users.last_name, dt_users.lastlogin, dt_domains.domain, dt_domains.minimum_offer, dt_domains.bin_price
FROM dt_users
LEFT OUTER JOIN dt_domains ON dt_domains.owner =

Get rid of the GROUP BY