Your results are not clear. Please clarify.

-----Original Message-----
From: agus
[mailto:oracledba-ezmlmshield-x17263143.[Email address protected]
Sent: 05 January 2006 11:37 AM
To: LazyDBA Discussion
Subject: How To Select ?


Hi,

I have data like this :

Table1
Key_No Key_Name
000001 ABC_XXX
000002 ABD_XXX

Table2
Key_No Key_No2 Key_Qty Key_Del
000001 001 100 50
000001 002 100 0
000002 001 150 150
000002 002 175 175

how to select in 2 table ?
but I want the result like this
000001


thanks
ags


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------------------------------------------------------------------------------
Please note: This e-mail and its contents are subject to a disclaimer
which can be viewed at http://www.woolworths.co.za/disclaimer. Should
you be unable to access the link please e-mail [Email address protected]
and a copy of the disclaimer will be e-mailed to you.



Oracle LazyDBA home page