Re: Re: Re: Merging SQL Results


No such thing as a small change
	PerlMonks

Re: Re: Re: Merging SQL Results

by physgreg (Scribe)

on Aug 05, 2002 at 09:49 UTC ( #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!

Comment on Re: Re: Re: Merging SQL Results Download Code

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://187615]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others cooling their heels in the Monastery: (4)

As of 2023-12-03 13:22 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?