Two SQL questions.

Hello all,  

        I have two questions about SQL statements:  

        1)How to know the version of SQL*NET in SQL*PLUS? (i.e. by which SQL statement)  

        2)Assume three tables in Oracle.  

        Table     Attributes
        -----     ----------
        T1        A, B
        T2        A, C
        T3        A, D
 
        A  B            A  C            A  D
        -----           ----            -----
        a1 b1           a1 c1           a1 d1
        a2 b2           a1 c2
        a3 b3                           a1 d3
 
        I want the result is:
 
        row1: a1 b1 c1 d1
        row2: a2 b2 c2
        row3: a3 b3    d3
 
        How to do this by a single SQL statement?
 

Thanks,
Stephen Received on Thu Sep 18 1997 - 00:00:00 CDT