/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

0 vote302 views1 answer
Max length found in mysql
SQL
0 vote291 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote283 views1 answer
Mysql docker image arjun
SQL
1 vote291 views3 answers
Update from select sqlite
SQL
0 vote277 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
9 votes283 views4 answers
How to create new user and database postgresql in ubuntu
SQL
26 votes292 views2 answers
Mysql workbench download
SQL
2 votes291 views1 answer
Update with join sql server
SQL
0 vote336 views1 answer
Parent and child link in mysql
SQL
0 vote272 views1 answer
Add sqlite3 in lumen
SQL