Consider the following query. SELECT COLUMN1, COLUMN2 FROM TABLE1 A LEFT JOIN TABLE2 B A.COLUMN_NAME = B.COLUMN_NAME What is the expected output? Only COLUMN1 and COLUMN2 from the 2 tables are retrieved for corresponding entries of COLUMN_NAME in TABLE1 and TABLE2 All relevant entries from TABLE1 are retained, along with a few entries from TABLE2 with matching entries in COLUMN_NAME for TABLE1 and TABLE2 All relevant entries from TABLE2 are retained, along with a few entries from TABLE1 with matching entries in COLUMN_NAME for TABLE1 and TABLE2 All entries of COLUMN1 and COLUMN2 from TABLE1 and TABLE2 are retrieved