I have three tables that all have "loan" in common.

Property
Investorloans
Loans

I used the following statements to pull all the loans for the investorid (03, 04, 06, 10) by matching the loan number(s) from each table.

I also want to join the information from the property file to the result set (again, "loan" is the common record match".

SELECT investorloans.i nvestorid,...