/SQL/How to know if table in rigt or left in sql

How to know if table in rigt or left in sql

-- People:           -- Car
id | name            owner_id | model
---+------------     ---------+------------
1  | Paul            1        | Ferrari
2  | Nancy           2        | Porsche
3  | Arthur          NULL     | Lamborghini
4  | Alfred          10       | Maserati

> select people.name, car.model from people join car on car.owner_id=people.id;

name     | model
---------+--------------
Paul     | Ferrari
Nancy    | Porsche
2 record(s) found

> select people.name, car.model from people left join car on 
  car.owner_id=people.id;

name     | model
---------+--------------
Paul     | Ferrari
Nancy    | Porsche
Arthur   | NULL
Alfred   | NULL     
4 record(s) found

> select people.name, car.model from people left join car on 
  people.id = car.owner_id;

name     | model
---------+--------------
Paul     | Ferrari
Nancy    | Porsche
Arthur   | NULL
Alfred   | NULL     
4 record(s) found

Source: stackoverflow.com

Similar codes

15 votes184 views5 answers
Show tables in oracle
SQL
2 votes182 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
3 votes183 views1 answer
Stpop start psql server
SQL
2 votes178 views6 answers
Mysql change timezone
SQL
2 votes170 views1 answer
Mysql sysdate
SQL
1 vote166 views2 answers
Reset mysqli fetch_arra
SQL
2 votes207 views1 answer
Tcl in sql
SQL
0 vote225 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
1 vote186 views1 answer
Window function mysql
SQL
4 votes174 views1 answer
Conda install sqlalchemy
SQL