/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 vote100 views1 answer
Power query case when
SQL
1 vote105 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote101 views1 answer
Sql sort ages
SQL
11 votes122 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote110 views1 answer
Merge clause with inner join
SQL
-1 vote113 views1 answer
Mysql select all columns and specific fields as
SQL
1 vote98 views2 answers
Mysql order by date asc null last
SQL
0 vote101 views1 answer
With_for_update sqlalchemy
SQL
4 votes107 views3 answers
Employee name starting with in sql
SQL
31 votes102 views3 answers
SQL Server change column data type
SQL