/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 vote265 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote210 views1 answer
Oracle procedure chain step
SQL
2 votes229 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote259 views1 answer
Drop view sql
SQL
0 vote228 views1 answer
Edit shchima table in sql
SQL
18 votes235 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
1 vote188 views1 answer
Stop mysql server mac
SQL
0 vote212 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
21 votes201 views1 answer
SQL cheat sheet pdf
SQL
0 vote215 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL