JOINing two datasets together, and merging columns together to get rid of nulls.

My SQL Server Udemy courses are:
----
In this view, we have the following views:
CREATE VIEW view1 as
SELECT object_id, name, create_date, schema_id
WHERE object_ID BETWEEN 1 AND 9
GO

CREATE VIEW view2 AS
SELECT object_id, name, modify_date, schema_id
WHERE object_ID BETWEEN 6 AND 17
GO
----
Each of these videos have got 6 rows, 4 of which are in both views.
In this video, I am going to merge these 2 views together, so that there is a total of 8 views. However, there will also be 8 columns, such as 2 object_id columns and 2 name columns. There will be a lot of NULLs where the rows are not in both views.
The next task is to merge the two object_id columns together, so that we get rid of the NULLs and have just one object_id.
In this video, I will use three different ways of doing this, using the CASE, ISNULL and CASE WHEN ... IS NULL.

[Broomtwo]

I was playing around trying to figure out a similar situation, and this was precisely the answer I was looking for. Thanks!

[shadowitself]

great in fact of content and language :D
super comprehensive, thx

[centox]

This Channel is quite undervalued. High high quality contents!

[justthien]

Thank you, what if my data has numerous columns that I couldn't spend enough time to combine them as I wish, like what you did in the video?

[engraliraza]

How to combine two CSV if columns are the same for two CSV'S but row's are differently

[juanpauloalmazan]

can you make a video join two table with a date, wher table 1 is in day date and table 2 is in week date.