Re: Re: Re: Merging SQL Results


"be consistent"
	PerlMonks

Re: Re: Re: Merging SQL Results

by physgreg (Scribe)

on Aug 05, 2002 at 09:49 UTC ( [id://187615]=note: print w/replies, xml )

Need Help??

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

From my rather hazy recollection of SQL:

SELECT ir.name, ir.address, ge.name, 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 (ir.country = 'Ireland' AND ge.country = 'Germany')
OR  (ge.country = 'Germany' AND ir.country IS NULL)
OR  (ir.country = 'Ireland' AND ge.country IS NULL)
[download]

I haven't been able to test this, so please let me know if it works!