selecting records from four tables in mssql database

See more:

SQL

i am trying SELECT records from four different tables in mssql.
the quarry runs put no results is displayed. this is the quarry i used

SELECT P.Regdate, P.Assemblys, P.Surname, P.Othername, P.Gender, P.Nationality, P.Dateofbirth, P.Residentialaddress, P.Hometownaddress, P.Telephone, P.Email, P.Occupation, P.Maritalstatus, P.Nameofspouse, P.Mfullname, P.Mlivingstatus, P.Mhometown, P.Ffullname, P.Flivingstatus, P.Fhometown, P.NOKfullname, P.NOKresidence, P.NOKtelephone, C.Communicant, C.Holyspiritbaptism, C.Holyspiritbaptismdate, C.Holyspiritbaptismplace, C.Waterbaptism, C.Waterbaptismdate, C.Waterbaptismplace, C.Waterbaptismminister, C.Positionchurch, C.Cellgroups, M.Ministryname, O.Ministryname 
from tblPersonal P, tblChurchdetails C, tblMembershipministry M, tblMembershipotherministry O 
WHERE P.FormattedMembershipid= 'ATOM/000004' AND C.FormattedMembershipid= 'ATOM/000004' AND M.FormattedMembershipid= 'ATOM/000004' AND O.FormattedMembershipid= 'ATOM/000004'

please help me out