T-SQL equivalent to Python Pandas Concatenate

I have a few tables that I would like to merge in a similar way that Python Pandas Concatenate does. I do not want to replicate the information for it is rather large. I'd like to have a VIEW like behavior. Let me illustrate by a fake example that as far as I know would not work but just to properly explain what I would like to achieve.

Let us say I have these two tables:

CREATE TABLE table_1 (
    [a] [bigint] NOT NULL,
    [b] [bigint] NOT NULL,
    [c] [varchar] (32) NULL,
    [d] [bigint] NULL,
)
GO

CREATE TABLE table_2 (
    [a] [bigint] NOT NULL,
    [b] [bigint] NOT NULL,
    [c] [varchar] (32) NULL,
    [e] [varchar](256) NULL,
)
GO

Where a, b, c are equivalent but hold different data. d exists in table_1 but not in table_2 and e exists in table_2 but not in table_1.

Tables do not hold any common data. That is, a JOIN on any field would bring zero results.

I would like to be able to do the following (Or something equivalent rather. I know what I am showing is not doable):

CREATE VIEW MyUnion FROM(
SELECT * FROM table_1 UNION SELECT * FROM table_2) AS alldata;

In such a way that if I run:

SELECT * FROM MyUnion;

And would get something like (1 and One are just filler representing a generic number or string):

a       b       c       d       e
1       1       One     1       NULL
1       1       One     NULL    One

Is there any way to do anything like this without duplicating the data? (i.e. creating another table holding everything)

Thank you!

Something like this?:

CREATE VIEW MyUnion AS
SELECT
    a, b, c,
    d,
    CAST(NULL AS varchar(32)) AS e 
FROM table_1 
UNION ALL
SELECT
    a, b, c, 
    CAST(NULL AS bigint) AS d,
    e
FROM table_2 ;

StackExchange Database Administrators Q#278573, answer score: 7