I have attached a query,
I want to understand two things from the query.
1. what will be output of the query. Need an outline, like for eg, all records from table a joined with table B then unmatched records from table b.
2. What will be the output when i replace "join"(line 30) with right join.
Great, if someone will help me.