6 May
2012
6 May
'12
7:38 a.m.
Have you tried using a union like: SELECT type,email FROM lists,aliases WHERE lists.uid='user@example.com' UNION SELECT type,email FROM lists,aliases WHERE aliases.alias='user@example.com' and lists.uid=aliases.uid; Or (unless I have the wrong join) SELECT type,email FROM lists LEFT JOIN aliases ON lists.uid=aliases.uid WHERE lists.uid='user@example.com' OR aliases.alias='user@example.com'; Sent from my iPad On 06/05/2012, at 5:12 PM, Russell Coker <russell@coker.com.au> wrote:
SELECT type,email FROM lists,aliases WHERE lists.uid='user@example.com';
SELECT type,email FROM lists,aliases WHERE aliases.alias='user@example.com' and lists.uid=aliases.uid;