dear bener tuch kata mas nya yang perlu diperhatikan adalah field tersebut harus digroupkan.
Salam Basmal > ada data : > Misalkan dari data sample yg anda kasih saya berik nama field KodeID dan > Qty dan Nama Tabel Inventory > > KodeID Qty > aaaaaa 1000 > aaaaaa 200 > bbbbbb 2000 > bbbbbb 3500 > cccccc 200 > cccccc 100 > > Select KodeID, Sum(Qty) as Total_Qty > From Inventory > Group By KodeID > > > > Salam, > > Edi Herdiawan > > > > > uchenk dodit <[EMAIL PROTECTED]> > Sent by: [email protected] > 03/02/2007 03:05 PM > Please respond to > [email protected] > > > To > [email protected] > cc > > Subject > [indoprog-vb] query data sum ada beberapa jenis > > > > > > > > > hi para programmer vb mania > > saya ad kesulitan dalam query begini masalahnya : > > ada data : aaaaaa 1000 > aaaaaa 200 > bbbbbb 2000 > bbbbbb 3500 > cccccc 200 > cccccc 100 > > > persoalannya bagaimana buat query sum dari beberapa jenis data, > 'aaaaa',bbbbb','cccccc' klo di sum sekaligus menjadi bagaimana mohon > pencerahannya .Terimakasih > > > > --------------------------------- > Food fight? Enjoy some healthy debate > in the Yahoo! Answers Food & Drink Q&A. > > [Non-text portions of this message have been removed] > > > This email has been scanned for Viruses and Spam. For more information > please contact your local Information Security representative. > > > > IMPORTANT NOTICE: > This email may be confidential, may be legally privileged, and is for the > intended recipient only. > Unauthorised access, disclosure, copying, distribution, or reliance on any > of it by anyone else is prohibited and may be a criminal offence. > Please delete if obtained in error and email confirmation to the sender. > > [Non-text portions of this message have been removed] > > ~~~~~~~oooOOOooo~~~~~~~ Universitas Bunda Mulia IT Department 04022002-271900 Basmal
