In ASP.NET im using two tables as follws (fig a,b). [attachment]
Im want to use to contruct a table as fig3 ,can any one help me for this query with sample table and coding.
v.r.mahendran
Printable View
In ASP.NET im using two tables as follws (fig a,b). [attachment]
Im want to use to contruct a table as fig3 ,can any one help me for this query with sample table and coding.
v.r.mahendran
This design is called Pivot Table or CrossTab Query.
Before answering your question let me ask you what database are you using?