SQL or ACCESS help

[loverboy260]

i have two tables
Property[propertyId,landlordId,Street]
Landlord[landlordId,Street]

now i want to make a query in either SQL or ACCESS wherei want a list of all properties with landlords who do not live on the same property ie produce only results where the streets in either table dont match??

thnx

[Xandu]

Hey Thiefboy...

For your particular case:

Ask them to prepare a list of properties they own and dont live on. Then steal it.

X

[Desa]

Originally posted by loverboy260
i have two tables
Property[propertyId,landlordId,Street]
Landlord[landlordId,Street]

now i want to make a query in either SQL or ACCESS wherei want a list of all properties with landlords who do not live on the same property ie produce only results where the streets in either table dont match??

thnx

try this in ACCESS:

SELECT * FROM Property, Landlord
WHERE (((Property.landlordID)=[Landlord].[landlordID]) AND ((Property.Street)<>[landlord].[Street]));

[Big-G]

Originally posted by Desa
try this in ACCESS:

SELECT * FROM Property, Landlord
WHERE (((Property.landlordID)=[Landlord].[landlordID]) AND ((Property.Street)<>[landlord].[Street]));

Right.

But instead of 'select *' , use 'select Property.propertyID'

[loverboy260]

pata nahin yeh gandhu kahan sey beech mein a jata hai (big G not you ;) but Xgandhu! tried to ignore him but still the dog is barking!

but thanks big G and desa!

[loverboy260]

Originally posted by Xandu
Hey Thiefboy...

For your particular case:

Ask them to prepare a list of properties they own and dont live on. Then steal it.

X

or shove them up your arse