in reply to Re: Re: Merging SQL Results
in thread Merging SQL Results

From my rather hazy recollection of SQL:
SELECT, ir.address,, ge.address, ir.age, ge.age FROM table1 AS ir OUTER JOIN table1 AS ge ON ir.age = ge.age WHERE ir.age > 20 AND ( = 'Ireland' AND = 'Germany') OR ( = 'Germany' AND IS NULL) OR ( = 'Ireland' AND IS NULL)
I haven't been able to test this, so please let me know if it works!