Coba query ini:
SELECT Faktur, MAX(Opening) AS Opening, MAX([In]) AS [In], MAX(Out)
AS Out
FROM dbo.faktur
GROUP BY Faktur
Semoga bermanfaat
MOHAMAD WASISTO
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Juned Syafruddin
Sent: 14 April 2008 12:58
To: [email protected]; [EMAIL PROTECTED]
Subject: [Programmer-VB] Tanya QUery
Dear Programmer
mohon bantuannya
Saya punya Tabel seperti ini
NO FAKTUR , OPENING, IN, OUT
AA 100 0 0
AA 0 50 0
AA 0 0 30
Bagaimana Menghasilkan Tampilan Seperti ini
NO FAKTUR , OPENING, IN, OUT
AA 100 50 30
Terima kasih
