Sabtu, 29 November 2014

Re: [MS_AccessPros] Error: Could not delete from the specified tables (MS Access 2010 or 2013)

 

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