Toad World® Forums

Left Outer Join

Greetings!

When I run the script below with comments on, I get 13147 rows. When I remove the comments, I get 12689 rows. I want to get 13147 rows. I am missing something in the left outer join. Will someone please tell me what is it that I am missing?

4532.LeftOuterJoin.jpeg

It’s quite possible that the extra SHRLGPA table is adding extra rows. Run the query both ways, and then use Toad’s Compare Data facility to identify exactly which rows are missing/added. Good chance the diff details will give you a clue about where the rows are coming from.

Thanks Gary for introducing me to Compare File feature. I will play with it and see if I can figure out the reason for missing data.