Toad World® Forums

Left Join do NOT show no matching rows

Hello,

I have here a very weird problem, I used “Left Join” and I am sure, there are NO matching rows in the links table, but TOAD show me only the matching rows, the not matching rows I can’t see and can’t find.

The following is the query I used, it is just a very simple query, perhaps is there some settings in TOAD, that let me only see the matching rows?

select a.reason, b.VWZ_1

from a

left join b

on a.reason=b.VWZ_1

that is weird. I was expecting a where clause with b.fieldx = something which would negate the left join and make it an inner join. So you have no records where b.VWZ_1 is null when you run that query and you are positive that table a has records with a reason that is not in table b? Maybe it is the other way around try table b left joined to a.

Try this to see all rows, martching and others…

select a.reason, b.VWZ_1

from a

full outer join b

on a.reason=b.VWZ_1