John,
Now I see that the designer is not perfect.
The puzzle now I have is the following:
No records executed when I run the following SQL:
SELECT tblOwner.*
FROM tblOwner
WHERE (tblOwner.OwnerpolicyNo) not In (SELECT PolicyNo FROM tblMaster);
1005 records executed:
SELECT tblOwner.*
FROM tblMaster RIGHT JOIN tblOwner ON tblMaster.PolicyNo = tblOwner.OwnerpolicyNo
WHERE (tblMaster.PolicyNo) Is Null;
I am not understanding why.
Norbert
__._,_.___
Posted by: drnorbert@msn.com
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar