Author |
Message |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8455 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 8:38 pm: | |
Gochi :piccha fastgaa unnaavgaa hemesh
migilinavi PO issues..vendor bank setups etc gochesh..oka assalainadi undi..PO approval hierarcy, apporval limits, evadiki PO create chese rights unnay, evariki approve chese rights unnay...veetiki data pampanu internal auditors ki...aame evo 10 questions tho mail kottindi..ippudu andulo okokkati soodali..... |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8454 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 8:36 pm: | |
Racchamass :ammani pipty miss
|
Racchamass
Celebrity Bewarse Username: Racchamass
Post Number: 16882 Registered: 01-2005 Posted From: 76.182.87.40
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 8:33 pm: | |
ammani pipty miss Our greatest glory is not in never falling, but in rising every time we fall |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57427 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 8:32 pm: | |
piccha fastgaa unnaavgaa hemesh
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8453 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 8:30 pm: | |
inka oka 3 tasks unnay anthe... |
Racchamass
Celebrity Bewarse Username: Racchamass
Post Number: 16880 Registered: 01-2005 Posted From: 76.182.87.40
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 8:30 pm: | |
49 Our greatest glory is not in never falling, but in rising every time we fall |
Beer
Yavvanam Kaatesina Bewarse Username: Beer
Post Number: 4966 Registered: 09-2006 Posted From: 66.30.108.90
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 8:29 pm: | |
hemu .. Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Racchamass
Celebrity Bewarse Username: Racchamass
Post Number: 16878 Registered: 01-2005 Posted From: 76.182.87.40
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:51 pm: | |
saala matter undi kada taadu lo Our greatest glory is not in never falling, but in rising every time we fall |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8452 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:49 pm: | |
inka oka 12 tasks paina unnay cheyyalsinavi..ide intha time pattindi |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8451 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:48 pm: | |
hmm...evaro kani bagane idea ichadu pivot ani...asala xls file ni ala soothante kannula pandaga ga undi..kiki. US and Canada vendors ki run chesi pampesa... |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57422 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:40 pm: | |
emo ayyundocchu....IP soosthe georgia state soovisthaandhi
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8450 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:39 pm: | |
emo mari.. |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57421 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:38 pm: | |
inthaki ee gochidada evalu......
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8449 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:37 pm: | |
thanks beeresh for the basic query...thanks gochidada for the pivot query...thanks goches for the continous support and max help...kiki. |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57420 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:35 pm: | |
venjoyy.....
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8448 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:33 pm: | |
run ayyindi gochesh..kiki.. SELECT Vname, Vnum, max(decode(payment_month, 'JUL-07', payment_amount, null)) "Jul-07", max(decode(payment_month, 'AUG-07', payment_amount, null)) "AUG-07" FROM (SELECT pv.vendor_name Vname, pv.segment1 Vnum, to_char(ac.check_date, 'MON-YY') payment_month, sum(aip.amount) Payment_Amount FROM ap_invoice_payments aip, ap_invoices ai, ap_checks ac, po_vendor_sites pvs, po_vendors pv, ap_bank_accounts aba, ap_terms at_v, ap_terms at_vs WHERE aip.invoice_id = ai.invoice_id AND aip.check_id = ac.check_id AND ai.vendor_site_id = pvs.vendor_site_id AND pvs.vendor_id = pv.vendor_id AND ac.bank_account_id = aba.bank_account_id AND pv.terms_id = at_v.term_id (+) AND pvs.terms_id = at_vs.term_id (+) AND ac.check_date BETWEEN NVL(:p_date_from,TO_DATE('01-JAN-1950', 'DD-MON-YYYY')) AND NVL(:p_date_to,SYSDATE) GROUP BY pv.vendor_name, pv.segment1, to_char(ac.check_date, 'MON-YY') order by to_char(ac.check_date, 'MON-YY'), pv.vendor_name) group by VName, VNum |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8447 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:32 pm: | |
naaku problem ardamaindi..correct chesthunna..running query.. |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8446 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:21 pm: | |
exactly gochesh..alage vasthundi data..oh ardamaindi..kani max pedithe indaka ichina error vasthundi |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57419 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:12 pm: | |
without max neeku ee format lo raavali data.... ID, July, August,September 1,400,-,- 1,-,500,- 1,-,-,600 max pedithe instead of 3 rows,you should get max grouped by each ID ID, July, August,September 1,400,500,600 ante blanks ni max tho filter chesthunnaavannamaata Bewarse Legend Of The Year 2008 Award winner |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57418 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:10 pm: | |
group by date theesettey problem undadhu hemesh....endukante manam aa calucations anni select clause lo chesi by date line by line isthunnaam.... aina date theesesaaka kooda same error endhi varitygaa
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8445 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:08 pm: | |
assala max enduku pettali??? |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8444 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:06 pm: | |
emaindi chippesh...nenu ee query ki oka half day chesa ante gundelu badukuntaru company vaallu..kiki. |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8443 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:06 pm: | |
same error..kani group by thesesthee assala beeresh ichindi raademo ga...ayina group by lo date di thesesina same error |
Shadow
Yavvanam Kaatesina Bewarse Username: Shadow
Post Number: 4774 Registered: 05-2008 Posted From: 68.198.151.34
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:04 pm: | |
|
Gochi
Bewarse Legend Username: Gochi
Post Number: 57417 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:03 pm: | |
emantaandhi ippudu Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8442 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:03 pm: | |
sesa gochesh... |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57416 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:02 pm: | |
kinda group by lo date theesesaa...try this SELECT pv.vendor_name Vname, pv.segment1 Vnum, max(decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount))) "Jul-07", max(decode(to_char(ac.check_date, 'MON-YY'), 'AUG-07', sum(aip.amount))) "AUG-07" FROM ap_invoice_payments aip, ap_invoices ai, ap_checks ac, po_vendor_sites pvs, po_vendors pv, ap_bank_accounts aba, ap_terms at_v, ap_terms at_vs WHERE aip.invoice_id = ai.invoice_id AND aip.check_id = ac.check_id AND ai.vendor_site_id = pvs.vendor_site_id AND pvs.vendor_id = pv.vendor_id AND ac.bank_account_id = aba.bank_account_id AND pv.terms_id = at_v.term_id (+) AND pvs.terms_id = at_vs.term_id (+) AND ac.check_date BETWEEN NVL(:p_date_from,TO_DATE('01-JAN-1950', 'DD-MON-YYYY')) AND NVL(:p_date_to,SYSDATE) GROUP BY pv.vendor_name, pv.segment1 order by pv.vendor_name Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8441 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 7:01 pm: | |
SELECT pv.vendor_name Vname, pv.segment1 Vnum, max(decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount))) "Jul-07", max(decode(to_char(ac.check_date, 'MON-YY'), 'AUG-07', sum(aip.amount))) "AUG-07" FROM ap_invoice_payments aip, ap_invoices ai, ap_checks ac, po_vendor_sites pvs, po_vendors pv, ap_bank_accounts aba, ap_terms at_v, ap_terms at_vs WHERE aip.invoice_id = ai.invoice_id AND aip.check_id = ac.check_id AND ai.vendor_site_id = pvs.vendor_site_id AND pvs.vendor_id = pv.vendor_id AND ac.bank_account_id = aba.bank_account_id AND pv.terms_id = at_v.term_id (+) AND pvs.terms_id = at_vs.term_id (+) AND ac.check_date BETWEEN NVL(:p_date_from,TO_DATE('01-JAN-1950', 'DD-MON-YYYY')) AND NVL(:p_date_to,SYSDATE) GROUP BY pv.vendor_name, pv.segment1, to_char(ac.check_date, 'MON-YY') order by pv.vendor_name |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57415 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:58 pm: | |
kindha group by add seyyu migathaa columns ki (columns not having max in select clause).... Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8440 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:56 pm: | |
Gochi :alaa aithe mundu oka max padeyyi
not a single group group functionantundi max add chesthe.. ORA-00937 not a single-group group function Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression is included in a GROUP BY clause. Action: Drop either the group function or the individual column expression from the SELECT list or add a GROUP BY clause that includes all individual column expressions listed. |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8439 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:54 pm: | |
|
Shadow
Yavvanam Kaatesina Bewarse Username: Shadow
Post Number: 4773 Registered: 05-2008 Posted From: 68.198.151.34
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:49 pm: | |
aythey ee work ki nuvvu chese billing lo 50% db ki kattu |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57414 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:49 pm: | |
alaa aithe mundu oka max padeyyi....decode and case statement are exactly the same.... max(decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount))) "Jul-07", Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8438 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:47 pm: | |
Shadow :Bemmam db valla chetha work seyichhavantey na
em seyyanu mama...3 days postpone sesaa query dorakka..query dorikaka ee problem |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8437 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:46 pm: | |
Idi work ayyindi gochesh.. decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount)) "Jul-07", just 2 months ki try chesa... vendor1 ki 2 rows vachi okokka row lo okokka month ki display avuthunnay values...so adi correct cheyyali... |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57413 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:44 pm: | |
shado baa
Bewarse Legend Of The Year 2008 Award winner |
Shadow
Yavvanam Kaatesina Bewarse Username: Shadow
Post Number: 4772 Registered: 05-2008 Posted From: 68.198.151.34
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:42 pm: | |
Bemmam db valla chetha work seyichhavantey na |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57412 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:33 pm: | |
select max(case when (year(payment_date) = 2007 and month(payment_date) = 07) then sum(payment)) "July-07", idhi try chesi choodu.... Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8436 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:33 pm: | |
ippudu endo missing keywork antundi..sare chostha aagu.. |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8435 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:28 pm: | |
Gochi :select max(case when to_char(payment_date,'MON-YY') = 'Jul-07' then sum(payment)) "July-07", max(case when to_char(payment_date,'MON-YY') = 'Aug-07' then sum(payment)) "Aug-07", etc etc... ilaa raasi choodu hemesh, okko nelaki okkoka line raayali.....appudu column wise pivot avuthundi
invalid relational operator = antundi...tochar annamana endi?? |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57411 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:26 pm: | |
Registered: 01-2007 eppudo register sesukuni after 2yrs ippudu postings settunnaava gochidada
Bewarse Legend Of The Year 2008 Award winner |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57410 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:21 pm: | |
select max(case when to_char(payment_date,'MON-YY') = 'Jul-07' then sum(payment)) "July-07", max(case when to_char(payment_date,'MON-YY') = 'Aug-07' then sum(payment)) "Aug-07", etc etc... ilaa raasi choodu hemesh, okko nelaki okkoka line raayali.....appudu column wise pivot avuthundi Bewarse Legend Of The Year 2008 Award winner |
Gochi
Bewarse Legend Username: Gochi
Post Number: 57409 Registered: 07-2004 Posted From: 24.229.138.244
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:15 pm: | |
eee gochidada evalu
Bewarse Legend Of The Year 2008 Award winner |
Shadow
Yavvanam Kaatesina Bewarse Username: Shadow
Post Number: 4771 Registered: 05-2008 Posted From: 68.198.151.34
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:13 pm: | |
>>If you want to know more about it, there is this website called www.google.com
|
Shadow
Yavvanam Kaatesina Bewarse Username: Shadow
Post Number: 4770 Registered: 05-2008 Posted From: 68.198.151.34
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:12 pm: | |
Gochidada, olu nuvvu |
Gochidada
Pilla Bewarse Username: Gochidada
Post Number: 4 Registered: 01-2007 Posted From: 67.159.44.138
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:10 pm: | |
Pivot query is just a way of cheating regular query to get the desired output in column format. google it and you will see many examples. |
Gochidada
Pilla Bewarse Username: Gochidada
Post Number: 3 Registered: 01-2007 Posted From: 67.159.44.138
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:08 pm: | |
you have to use pivot query to see column wise output. If you want to know more about it, there is this website called www.google.com |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8434 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:07 pm: | |
Gochidada :you have to use pivot query to see column wise output
idendi...???? |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8433 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 6:00 pm: | |
bagane work avuthundi kaani rows lo vasthundi... thanks beeresh... |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8432 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 5:53 pm: | |
beeresh...aagu sootha...nenu inka each month ki ichi payment_date between ani save cheshunna file ni |
Gochidada
Pilla Bewarse Username: Gochidada
Post Number: 1 Registered: 01-2007 Posted From: 67.159.44.138
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 5:50 pm: | |
Ravanabrahma :
wonder what is your job title ,your billing rate, years you have been working here |
Beer
Yavvanam Kaatesina Bewarse Username: Beer
Post Number: 4965 Registered: 09-2006 Posted From: 66.30.108.90
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 5:50 pm: | |
select to_char(payment_date, 'MON-YY'), sum(payment) from table group by to_char(payment_date, 'MON-YY') order by to_char(payment_date, 'MON-YY') Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8431 Registered: 06-2004 Posted From: 65.196.167.82
Rating:N/A Votes: 0(Vote!) | Posted on Sunday, January 11, 2009 - 5:35 pm: | |
payment_date month ni batti sum chesi different months ki rastham elagu?? |
Ravanabrahma
Mudiripoyina Bewarse Username: Ravanabrahma
Post Number: 8430 Registered: 06-2004 Posted From: 65.196.167.82
Rating: Votes: 1(Vote!) | Posted on Sunday, January 11, 2009 - 5:30 pm: | |
Vendor payments ki query raayali..Jul-07 to Dec-08 varaku.. oka month lo vendor ki chala invoices payment untundi..like Jul-07 lo oka 20 invoices(with different payment dates) untay..ippudu emi data kaavali ante.. Vendor_name Jul-07 Payment, Aug-07Payment, Sep-07 Payment,..... each month ki sum chesi raavali query...elaa raayali adi?? |