I found that the resultant table after inner join and outer join from the same two joining tables could be the same. So what is the essential difference between inner join and outer join? Thanks for your inputs.