To fetch the data from different tables

[srikantha_nagaraj]

I have two tables and 3 columns in each table.Each column contains 5 rows T1-- T2-- c1 c2 c3 b1 b2 b3 1 6 11 a b c 2 7 12 d e f 3 8 13 g h i 4 9 14 j k l 5 10 15 m n o I want data as Final Table c1 b2 1 b 2 e 3 h 4 k 5 n Please suggest solution for this. I have to show this in gridview.

[Mycroft Holmes]

Are you using winforms DataGridView or webforms GridView. If it is GridView then you need to take this question to the ASP forum.

Never underestimate the power of human stupidity RAH

[Kschuler]

What are the column names, and how does the data in the two tables link to each other? It looks like you are grabbing the first column of the first table and the second column of the second table, so if these are in a database and you are trying to pull the data it will look something like this: SELECT Table1Column1, Table2Column2 FROM Table 1 JOIN Table 2 ON Table1KeyColumn=Table2KeyColumn Is this what you were looking for?