Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets
Bewarse Talk Discussion Board * Archives - 2012 * SQL Query help < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Blazewada
Mudiripoyina Bewarse
Username: Blazewada

Post Number: 18182
Registered: 08-2008
Posted From: 220.255.1.115

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, April 09, 2012 - 1:49 am:    Edit Post Delete Post View Post/Check IP

group by invoice number use cheste vastadi lemme try and get back
Android Rocks
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post View Post/Check IP

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?

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration