Toad World® Forums

Left Outer Join


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?


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.