SELECT * FROM property!propnum WHERE LEFT(Propnum.groupid,2) == "PN"
SELECT pocontact.* FROM property!pocontact JOIN property!propnum ; ON Pocontact.memoid = Propnum.contactid AND LEFT(Propnum.groupid,2) == "PN"