cara filter 2 tabel

mamazaka

02-11-2012 09:29

cara filter 2 tabel

agan2 ane mau tanya cara filter data yg belum bayar iuran bgmn y gan

ini contoh viewnya
yg ane bt tp itu nampilin yg dh bayaran.
ane mauny yg blm bayran bgmn yg gan

Spoiler for view:

SELECT
TOP (100) PERCENT dbo.invoice.paidDate, dbo.invoice.studentID, dbo.student.studentName, dbo.invoice.description, dbo.invoice.amount
FROM dbo.invoice INNER JOIN
dbo.student ON dbo.invoice.studentID = dbo.student.studentID
WHERE (dbo.invoice.description NOT LIKE '%Penjualan%') AND (dbo.invoice.description NOT LIKE '%Uang Pendaftaran%') AND (dbo.invoice.description NOT LIKE '%Rp 370,000%') AND
(dbo.invoice.description NOT LIKE '%Rp 320,000%') AND (dbo.invoice.description NOT LIKE '%Rp 185,000%') AND (dbo.invoice.description NOT LIKE '%Rp 160,000%')
GROUP BY dbo.invoice.paidDate, dbo.invoice.amount, dbo.invoice.studentID, dbo.invoice.description, dbo.student.studentName
ORDER BY dbo.invoice.paidDate

maklum gan baru belajar SQL

1.1K

Kutip

Balasan

Komentar yang asik ya

Urutan

Terbaru

Terlama

Komentar yang asik ya

Komunitas Pilihan