That worked great, thanks.

>Hi Jim,
>
>I still think that it shouldn't be complicated to do with one query.
>The Ownership table opened with alias 'cl' will return all the properties associated with current loan cl.loan_id = lnLoanID.
>The Ownership table opened with alias 'lnk' will return all loans associated with those properties by JOINing to 'cl' cl.prop_id = lnk.prop_id.
>The rest should be self-explanatory.
>
>

>SELECT Loan.* FROM Loan
>		JOIN Ownership lnk ON Loan.id = lnk.loan_id
>		JOIN Ownership cl ON cl.prop_id = lnk.prop_id AND cl.loan_id = lnLoanID
>	WHERE Loan.id <> lnLoanID
>

>