Suppose we have the following columns, what will be the output for an inner join: col1 col2 1 1 1 null null null 1 1 1 blank blank blank

The output for inner join will be the rows where both col1 and col2 have non-null values.

• Inner join returns only the matching rows from both tables.

• In this case, the output will be the rows with non-n...read more