If suppose I have one table Customers,fields Cus_Id as primary key,Cus_Name and Second table i.e., Orders table,Order_Id as primary key,Cus_Id reference to the Customers table,and Order_date.
Now my Question is that,I want to display the data like this:
Cus_Name 1996 1997 1998
Cus_1 8 5 1
Cus_2 5 3 2
Cus_3 4 0 4
Cus_4 11 25 0
And Year should be dynamically growable.
So I can judgement that,why Cus_4 has not been ordered in year 1998?
Suggestion is required........