/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 vote349 views1 answer
Oracle grant on all tables in schema
SQL
0 vote337 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote322 views1 answer
Sql if else in select
SQL
13 votes364 views2 answers
Get date from now() mysql
SQL
0 vote352 views2 answers
Call to undefined function mysql_query()
SQL
2 votes336 views1 answer
Columns Present in a table
SQL
0 vote331 views1 answer
Sql select with apostrohpe
SQL
0 vote335 views1 answer
Sql server select furst day of current year
SQL
0 vote312 views1 answer
Full syntax inner join
SQL
7 votes363 views3 answers
Sql set
SQL