    
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 19625
Registered: 06-2004
Posted From: 99.67.73.204
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, April 09, 2012 - 12:18 am: |
|
naaku oka table lo ila undi data..
invoice_num, dr_data, cr_data, segment, line_num
1 -12 32 2 4
1 -12 32 3 5
nenu single row nee display cheyyali for invoice_num 1..segment values 2 and 3 are constant. dr_data will be the dr_data of the row that has segment value 2 and cr_data will be the cr_data that has segment value 3 and line_num should be concatenation of the line_num from both the rows seperated by ,
output should be
invoice_num, dr_data, cr_data, line_num
1 -12 32 4,5
ela rayali query? |
Archives - 2012