RE: Corrected SQL Question...

I think those solutions should be acceptable. Not sure if they are displaying any more information from the table. I was just given the test table to get the SQL script working....

Thanks a lot.

• Kirti

-----Original Message-----
Sent: Thursday, March 13, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L

I think its easier if you do it cross-tab

AUS DAL DAL AUS Is that acceptable?
Or just select

AUS DAL If it also has a DAL AUS

Are either of those metods acceptable? If so, pick one and Ill show you how to do it.
>
> From: "Deshpande, Kirti" <kirti.deshpande_at_verizon.com>
> Date: 2003/03/13 Thu AM 11:19:15 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Corrected SQL Question...
>
> Okay, let me do this right this time,... (Now that I have my hot tea going;)
>
> Here is the test data:
>
> SQL> select c1,c2 from cp;
>
> C1 C2
> --- ---
> AUS DAL
> AUS HOU
> DAL AUS
> DAL HOU
> DAL LIT
> DAL XYZ
> HOU AUS
> HOU DAL
> HOU LIT
> HOU XYZ
> LIT DAL
>
> C1 C2
> --- ---
> LIT HOU
> XYZ DAL
> XYZ HOU
>
> 14 rows selected.
>
> SQL>
>
> Here is what is required:
>
> C1 C2
> --- ---
> AUS DAL
> DAL AUS
> AUS HOU
> HOU AUS
> DAL HOU
> HOU DAL
> DAL LIT
> LIT DAL
> DAL XYZ
> XYZ DAL
> HOU LIT
> LIT HOU
> HOU XYZ
> XYZ HOU
>
>
> I think I am clear now...
> Sorry about the wrong test data earlier...
>
>
> Thanks,
>
> - Kirti
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).