I have 2 tables (Table1 and Table2).

Table1 & Table2 have the same column names, but Table2 has a few extra columns than Table1.

Column Names as follows:

* Table1 [Name, Surname, Age, Gender, Height]
* Table2 [Name, Surname, Age, Gender, DateOfBirth, Origin]

I am trying to get the data from both tables into 1 gridview.

Ive tried using UNION ALL but it throws back an error because the columns arent the same.

Is it possible to join all these columns into 1 gridview and display the data accordingly?

Eg: Name, Surname, Age, Gender, Height, DateOfBirth, Origin

If so what would my sql query look like?

PS: I have 70+ columns in each table so individually selecting this is not going to work out