I have following 2 tables t1, t2

CREATE TABLE t1 (
id INT PRIMARY KEY
);

CREATE TABLE t2 (
id INT PRIMARY KEY
);

INSERT INTO t1 VALUES (1),(2),(3);
INSERT INTO t2 VALUES (2),(3),(4);

I am running

select * from t1 left join t2 using(id);

Result:

+----+
| id |
+----+
|  1 |
|  2 |
|  3 |
+----+

On running script:

select t1.id, t2.id from t1 left join t2 using(id);

Result:

+----+------+
| id | id   |
+----+------+
|  1 | NULL |
|  2 |    2 |
|  3 |    3 |
+----+------+

select * is supposed to return all the columns, so, why I am not getting 2 rows when I am using select *?

Note: I am using Mysql