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

Oracle LazyDBA home page