i have 2 tables:
1 . places : columns(PlaceID,PlaceName)- PlaceID is Prim and AutoInc.
2. PeoplePlaces:columns(PlaceID,MemberNo)
my query is:
Code: Select all
select places.* from places RIGHT JOIN peopleplaces ON places.PlaceID=peopleplaces.PlaceID WHERE peopleplaces.MemberNo='26'
The above query return me only the PlaceID , the PlaceName is NULL or empty
why is that ?
Thanks for help
moshe.b