RE: Corrected SQL Question...

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Thu, 13 Mar 2003 12:24:27 -0800
Message-ID: <F001.00569822.20030313122427@fatcity.com>

All they wanted was to "pair up" those city codes. DAL -- AUS followed by AUS -- DAL,
AUS -- HOU followed by HOU -- AUS
etc...
and on separate lines.
So, cross-tab did not have the right format.

I sent them Jacques Kilchoer's solution (he also sent me a simplified one, without the UNION), and it was acceptable. Problem solved, as there are no more questions :)

• Kirti

-----Original Message-----
Sent: Thursday, March 13, 2003 1:46 PM
To: Multiple recipients of list ORACLE-L

Questions I would have for those who wrote the requirements: Of possible combinations of the form ABC XYZ XYZ ABC, which do they want?

As can be seen from the answers sent to the list, there is more than one set of responses that give this pattern. If they only want "half" of the possible patterns, which half is the correct half?

--

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). Received on Thu Mar 13 2003 - 14:24:27 CST