in reply to Re: Merging SQL Results
in thread Merging SQL Results
Ok I'm obviously not after making myself clear. Probably for the same reason you have no SQL samples in your answer ;-)
Basically what I want to do is display two tables beside each other. Thats it. So say I have two statements select name, address fom table1 where age > 20 and country = "Ireland" select name, address fom table1 where age > 20 and country = "Germany" instead of displaying two tables one above the other (as below) I'd like to merge them (as further below)
Basically what I want to do is display two tables beside each other. Thats it. So say I have two statements select name, address fom table1 where age > 20 and country = "Ireland" select name, address fom table1 where age > 20 and country = "Germany" instead of displaying two tables one above the other (as below) I'd like to merge them (as further below)
Ireland; john;cork;21; pat;dublin;22; Eoin;galway;33; Germany; holger;stuttgart;21; jens;berlin;22; stefan;dresden;23;
Ireland; Germany; john ; cork ; holger ; stuttgart ; 21 ; pat ; dublin ; jens ; berlin ; 22 ; Eoin ; galway ; -- ; -- ; 33 ; -- ; -- ; stefan ; dresden ; 23 ;
j o h n i r l .
Sum day soon I'Il lern how 2 spelI (nad tYpe)
In Section
Seekers of Perl Wisdom