Mohon pencerahan.
 

Saya punya table dg isi sbb.
 
Ord_no  Inv_no  Ord_qty  Ord_val  Inv_qty Inv_val 
-------------------------------------------------
  O1      V1                         2      1000      
  O1      V1                         5      2500
  O1               2      1000
  O1               5      2500
 
Bagaimana querynya jika saya ingin melihatnya sbb.

Ord_no  Inv_no  Ord_qty  Ord_val  Inv_qty  Inv_val
--------------------------------------------------
  O1      V1       2      1000       2      1000
  O1      V1       5      2500       5      2500

 

Mohon penjelasan dari teman2

Thx

 

 



[Non-text portions of this message have been removed]





--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com 
Yahoo! Groups Links






 







--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indo-oracle/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/indo-oracle/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[EMAIL PROTECTED] 
    mailto:[EMAIL PROTECTED]

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Kirim email ke