/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 vote346 views1 answer
Sql list dates between two dates
SQL
1 vote353 views4 answers
Sql now
SQL
0 vote368 views3 answers
Postgres date difference seconds
SQL
0 vote342 views1 answer
How to get data between a last week in mysql
SQL
0 vote341 views1 answer
MySql get primary keys of table
SQL
2 votes329 views1 answer
How to select first row of database sql
SQL
6 votes349 views2 answers
Find mysql version linux
SQL
0 vote353 views1 answer
Group by join columns per table
SQL
0 vote396 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote373 views1 answer
Hour and minute between two datatime sql
SQL