/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

1 vote224 views1 answer
Ubuntu access database from terminal
SQL
0 vote222 views1 answer
Get a list of tables and the primary key
SQL
8 votes230 views1 answer
Sql limit results returned
SQL
6 votes230 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote179 views1 answer
Flask_sqlalchemy install
SQL
1 vote289 views1 answer
Sql and
SQL
3 votes209 views1 answer
MySQL DELETE JOIN
SQL
5 votes204 views1 answer
How to check port number for postgresql
SQL
4 votes208 views1 answer
Check database name postgresql
SQL
2 votes223 views2 answers
Postgres select duplicate columns
SQL