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