SQL & PL/SQL

Hi Guys,

I have spotted a very unusual behaviour that I can't explain.

I have isolated the problem to the following joins.

Why does the second join return less rows? Why does the first JOIN result in more rows?

         LEFT OUTER JOIN DWH.SA_BEZ_SAS_GRUPPE_V stellwerkg 
              INNER JOIN DWH.SA_STELL_V stellwerk   
                      ON (stellwerkg.owner_fid = stellwerk.fid)          
                      ON (stellwerkg.member_fid = vorsignal.fid)
--5413 rows

         LEFT OUTER JOIN DWH.SA_BEZ_SAS_GRUPPE_V stellwerkg
                      ON (stellwerkg.member_fid = vorsignal.fid) 
              INNER JOIN DWH.SA_STELL_V stellwerk   
                      ON (stellwerkg.owner_fid = stellwerk.fid)

--5411 rows

Thanks for any enlightenment.