SELECT *; FROM property!propnum LEFT OUTER JOIN property!pocontact ; ON Propnum.contactid = Pocontact.memoid; WHERE SUBSTRC(Propnum.groupid,1,2) = "PN"; ORDER BY Propnum.nproperty>- fields mapping
Field Names with Data Type and Length Table : PNVIEW Field Size 1: Lcancel L(1) 2: Donated L(1) 3: Nproperty I(4) 4: Dateissue D(8) 5: Cinvoice C(9) 6: Serialno C(17) 7: Acqcost N(12) 8: Descrip C(35) 9: Orgcode C(11) 10: Groupid C(9) 11: Notes M(4) 12: Dup_pn N(4) 13: Contactid I(4) 14: Memosent L(1) 15: Memorecvd L(1) 16: Inputuser C(15) 17: Inputdate D(8) 18: Memoid I(4) 19: Send_fname C(20) 20: Send_lname C(25) 21: Send_add1 C(40) ___ 233>- n° records