/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 vote327 views3 answers
Drop unique key constraint in sql server
SQL
14 votes331 views4 answers
Online sql compiler
SQL
1 vote316 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
1 vote320 views1 answer
Pv mysql import
SQL
16 votes333 views4 answers
Find duplicates mysql
SQL
0 vote329 views1 answer
ORA-00942
SQL
1 vote346 views2 answers
Sql split string by space
SQL
8 votes326 views1 answer
Mac restore mysql database command line
SQL
0 vote306 views1 answer
SQL get max per id
SQL
3 votes338 views2 answers
Postgres inner join vs join
SQL