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

 

Norbert-

That makes no sense!  If you go looking for one of the OwnerPolicyNo values returned by the second query in tblMaster, do you find it?  (SELECT PolicyNo FROM tblMaster WHERE PolicyNo = xxxx)

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Nov 29, 2014, at 3:01 PM, drnorbert@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___