I would suggest changing the table designs. The query you request isn't
possible without a lot of assumptions, since there isn't any real key that
allows the tables to be joined. Is this just something that you made up?
If you have a real situation, then please enlighten us. This scenario isn't
real life, and really can't be solved.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"ykhlef Mourad" <ykhlef_at_yahoo.fr> wrote in message
news: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 Mon May 08 2000 - 00:00:00 CDT
