http://qs1969.pair.com?node_id=187608


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)

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)