/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 vote113 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
5 votes120 views4 answers
Upload database mysql command line
SQL
5 votes120 views4 answers
Change auto increment mysql
SQL
0 vote113 views1 answer
How to connect to mysql in ef 6
SQL
0 vote105 views1 answer
Array aggre distinct postgres
SQL
0 vote111 views1 answer
Oracle synonym procedure
SQL
2 votes117 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote117 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote115 views1 answer
SQL FROM-Klausel
SQL
8 votes108 views2 answers
Between operator
SQL