>SELECT Loan.* FROM Loan > JOIN Property p1 ON loan.id = p1.loan_id > JOIN Property p2 ON p2.id = p1.id AND p2.loan_id = lnLoanID > WHERE Loan.id <> lnLoanID >Hi Sergey,
Id I Not Null Autoinc Nextvalue 1 Step 1, ; LOANACCT C(20) Not Null, ; DISPLAY_ACCT C(20) Not Null, ; && and others specific to a given loan ...Property table
'PROPERTY.DBF ID I NOT NULL AUTOINC NEXTVALUE 18803 STEP 1, ; ORDER_DATE D NOT NULL, ; && others specific to a given propertyOwnership table
ID I NOT NULL AUTOINC NEXTVALUE 1 STEP 1 &&- PK PROP_ID I NOT NULL, ; && fk - PROPERTY LOAN_ID I NOT NULL, ; && fk - LOAN PCNT N(7, 6) NOT NULL ;