gistfile1.sql

SELECT mail.mail_name,domains.name,accounts.password,domains.status 
					FROM domains 
					LEFT JOIN mail ON mail.dom_id = domains.id 
					LEFT JOIN accounts ON accounts.id = mail.account_id 
					WHERE mail.mail_name <> ''