I am using SQL server 2012. I would like to generate a sql view where I got all records from tableA. And below these results I would like to have the results from tableB. There are no relations between these 2 tables. The columns are also differant. Here is an example:
tableA: tableB:
+-------------------------+ +--------------------------------+
| Name | Year
--------------------------- +---------------------------------
| A | | 2000 |
| B | | 2001 |
| C | | 2002 |
I would like to have results like this:
+-------------------------+
| Name | Year
------------------------
| A |
| C |
| D |
| | 2000
| | 2001
| | 2002
How can I realize this? I see only joins, union solutions, but they dont work for me because I dont have some relation between these 2 tables.