/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 vote220 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote190 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote197 views2 answers
Postgresql get last day of month
SQL
0 vote211 views1 answer
Array aggre distinct postgres
SQL
0 vote183 views4 answers
How to drop all tables in sql
SQL
1 vote191 views1 answer
Mysql get character set
SQL
3 votes190 views2 answers
Funktion LOWER/UPPER sql
SQL
8 votes182 views2 answers
Phpmyadmin password
SQL
-1 vote194 views1 answer
Io
SQL
8 votes205 views1 answer
Check mysql version phpmyadmin
SQL