Re: Two SQL questions.

Hi Stephen,

I assume you meant the data values for table T2 to be:   a1 c1 and a2 c2
and for table T3 to be:
  a1 d1 and a3 d3.

If so, then using the following outer join gives your desired result:

  select t1.a, t1.b, t2.c, t3.d
    from t1, t2, t3
    where t1.a = t2.a (+) and

          t1.a = t3.a (+);

If your data was correct as posted, then I'd have to give it a second thought.

Bob

In article <34218647.1CDD_at_comp.polyu.edu.hk>,   stephen <c6635500_at_comp.polyu.edu.hk> wrote:
>
> 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

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet