Re: Two SQL questions.

From: <drippel_at_perspect.com>
Date: 1997/09/18
Message-ID: <34215eb8.15828059@news.erols.com>#1/1

this will work...
select t1.a a, t1.b b, t2.c c, t3.d d
from t1, t2, t3

where   t1.a = t2.a
and     t1.a = t3.a
and     substr(t1.a,2,1) = substr(t2.c,2,1)
and     substr(t1.a,2,1) = substr(t3.d,2,1)

union
select t1.a, t1.b, t2.c, ' '
from t1, t2

where   substr( t1.a, 2, 1 ) = substr( t1.b, 2, 1 )
and     substr( t1.a, 2, 1 ) = substr( t2.c, 2, 1 )
and     t1.a <> t2.a

union
select t1.a, t1.b, ' ', t3.d
from t1, t3

where   substr( t1.a, 2, 1 ) = substr( t1.b, 2, 1 )
and     substr( t1.a, 2, 1 ) = substr( t3.d, 2, 1 )
and     t1.a <> t3.a

but in a simple single select
please stand by
On Thu, 18 Sep 1997 12:51:35 -0700, 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
Received on Thu Sep 18 1997 - 00:00:00 CDT