In a nutshell, this left join does not work in 5.5. Screen shot below is the
same query run in both Toad 5.5 and SSMS.
No record returned on right side of join for Toad editor.
I checked to make sure there were no spaces in the l.LoadNumber or n.LoadNum
fields, so I added a RTrim(LTrim()) around each and that did not work. I even
converted it to the same data type (varchar(20)) with no luck.
This query works fine in Toad 5.0 and 4.6