Unsure if my tables are correct for the query im trying

[BBK]

Im trying to get a query working that will selected all properties that have no lease(vacant)

I have tried countless ways but am unable to get it to return the correct results.

Is it even possible from my two tables show below.

Once again any assistance is greatly appreciated.

SELECT tblProperty.Address, tblProperty.Town, tblProperty.County
FROM tblProperty INNER JOIN tblLease ON tblProperty.PropertyID = tblLease.PropertyID;

 

[pbaldy]

Does the unmatched query wizard get the result you're after?

 

[BBK]

Thanks a million pbaldy, works perfect.

I feel so stupid when an answer is right there in front of me.

Thanks again for the help

 

[pbaldy]

No problemo, glad it worked for you.