Re: Please Help Me!

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 20 Jun 1998 15:01:01 GMT
Message-ID: <358fce29.6146097@192.86.155.100>

A copy of this was sent to "Á¤¿µÈ£" <dream_at_naray.co.kr> (if that email address didn't require changing) On Sat, 20 Jun 1998 10:30:45 +0900, you wrote:

>Hellow Everyone
>
>I Have A Problem In Oracel Please Help Me!
>
>My Boss Gave To A Question But I Can't Solve It
>
>The Question
>
>sql> Select cust_no from Custom where cust_no in ('12121212',
>'12121212','12121213') ;
>

select cust_no
  from custom, ( select '12121212' x from dual

                 UNION ALL
                 select '12121212' x from dual
                 UNION ALL
                 select '12121213' x from dual ) b

where custom.cust_no = b.x
/

you have to join to achive what you want....

><cust_no Is Unique-key in Custom>
>
>We Run Above SQL Has 2-Rows , But My Boss Wants 3 Rows.
>
>How Can I Show 3 Rows ...
>
>ASAP - REmail Please < dream_at_naray.com >
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Jun 20 1998 - 10:01:01 CDT