SELECT mail.id, mail.mail_name, domains.name, accounts.password, mail.postbox, mail.mbox_quota, mail.redirect, mail.redir_addr, mail_group, mail.autoresponder FROM mail, accounts, domains WHERE mail.account_id = accounts.id AND mail.dom_id = domains.id AND domains.name = ‘domain.tld’;

Leave a Reply