I know about joins in SQL Server.
For example. there is two tables Table1, Table2.
There table structure are following.
create table Table1 (id int, Name varchar (10))
create table Table2 (id int, Name varchar (10))
left join Table2 on Table1.id = Table2.id
right join Table1 on Table1.id = Table2.id
Select * from Table1 left join Table2 ...
Select * from Table2 right join Table1 ...
are indeed completely interchangeable. Try however
Table2 left join Table1 (or its identical pair,
Table1 right join Table2) to see a difference. This query should give you more rows, since Table2 contains a row with an id which is not present in Table1.