Re: Juxtaposition

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/05
Message-ID: <957513835.26601.0.pluto.d4ee154e@news.demon.nl>#1/1

None as the tables are not related and a cartesian product (if you know what that is) is the only result you can get

Hth,

Sybrand Bakker, Oracle DBA

ykhlef Mourad <ykhlef_at_yahoo.fr> schreef in berichtnieuws 39127EBA.701D05D1_at_yahoo.fr...
> Hello every one,
>
> I have two tables T1 and T2
>
> T1 a
> ------
> 1
> 2
>
> T2 b
> ------
> a
> b
>
> What this the SQL query (not PLSQL query) that can yields
>
> T a b
> -------
> 1 a
> 2 b
>
>
> Thank u in advance
>
Received on Fri May 05 2000 - 00:00:00 CDT