note
johnirl
Ok I'm obviously not after making myself clear. Probably for the same reason you have no SQL samples in your answer ;-)<br>
Basically what I want to do is display two tables beside each other. Thats it. So say I have two statements <code> select name, address fom table1 where age > 20 and country = "Ireland" </code> <code>select name, address fom table1 where age > 20 and country = "Germany"</code> instead of displaying two tables one above the other (as below) I'd like to merge them (as further below)<p>
<code>
Ireland;
john;cork;21;
pat;dublin;22;
Eoin;galway;33;
Germany;
holger;stuttgart;21;
jens;berlin;22;
stefan;dresden;23;
</code><p>
<code>
Ireland; Germany;
john ; cork ; holger ; stuttgart ; 21 ;
pat ; dublin ; jens ; berlin ; 22 ;
Eoin ; galway ; -- ; -- ; 33 ;
-- ; -- ; stefan ; dresden ; 23 ;
</code>
<p>
<font color="green">j</font>
<font color="red">o</font>
<font color="blue">h</font>
<font color="orange">n</font>
<font color="cyan">i</font>
<font color="black">r</font>
<font color="magenta">l</font>
<font color="red">.</font>
<p>
<i> Sum day soon I'Il lern how 2 spelI (nad tYpe) </i>
187603
187606