Select statement To display each row as colum for Gridview control

[User 4005525]

Hi, I Have two tables. Table1 has the following columns: TableID FieldID FieldName FieldValue DateAdded and Table2 has the following Columns FieldID TableID Dataadded And I want to display Each FieldName as a Column name for Dridview control.How can i form SELECT Statement To Achieve this ? Thanks in advance sri

[Ashfield]

Don't cross post - I just answered this in the C# forum.

Bob Ashfield Consultants Ltd