Dealing with NULL values and EMPTY strings in UNION of two tables

Hands on SQL UNION/UNION ALL/IS NULL/IS NOT NULL/ISNULL()/COALESCE() functions with Complete queries Difference between Union and Union All in Detail(With Null Values ,Duplicate Values ,Diff DataType) Warning in SQL | Null value is eliminated by an aggregate or other SET operation SQL UNION and UNION ALL: Everything You Need to Know 29-SET Operators in SQL | Union | Union All | Intersect | Except or Minus | Examples | SQL Tutorial 6 SQL Joins you MUST know! (Animated + Practice) SQL \"difference between\" interview questions (part 1) The Right Way to Check for Null in C# MySQL: SUBQUERIES SQL Joins: Difference Between Inner/Left/Right/Outer Joins SQL | Count(*) vs Count(1) Vs Count(colname) #sqltips SQL | Union Vs Union ALL | Which has better performance? #sql Interview Questions - All JOINS (INNER, LEFT, RIGHT, FULL OUTER) | JOIN only NULL values output MySQL UNIONS are easy UNION SQL Injection to Extract Data From Other Tables! SQL injection UNION attack, determining the number of columns returned by the query SQL injection UNION attack, finding a column containing text SQL injection UNION attack, determining the number of columns returned by the query UNION Operator (SQL) - Combining Results (UNION, UNION ALL) Learn QL: Query 14: Null values IS NULL Working with SQL NULL values | Null Handling Functions SQL injection UNION attack, determining the number of columns returned by the query JOINing two datasets together, and merging columns together to get rid of nulls.