بســم الله الـرحمــن الرحيــم
السلام عليكــم ورحمـة الله وبركاتــة
منتديات الفريق العربي للبرمجة
cstomer_name 2008 2007 2006 2005 2004 2003 before
aaaa 1000 500 700 - - - 200
bbbb - - 1600 2000 2000 - -
cccc 550 200 5000 - - 7000 2900
need to create a view
thats return every customer name with sum of pending invoice for each year (only the first 6 years)
ie:
create view xx
as
select customer_name,pend(2008),pend(2007),pend(2006),pend(2005),pend(2004),pend(2003),
pend(before 2003)
from xxxx
Can you help me in creating the functions
& the big view?
note:
There is a column called (pending date) in the table.