SELECT TenantPayment.TenantPaymentID, TenantPayment.TenantPaymentDate, TenantPayment.TenantPaymentAmount, Tenant.TenantName, House.House, Owner.OwnerName, Owner.OwnerID
FROM ((TenantPayment INNER JOIN Tenant ON TenantPayment.TenantPaymentTenantID = Tenant.TenantID) INNER JOIN House ON Tenant.TenantHouseID = House.HouseID) INNER JOIN Owner ON House.HouseOwnerID = Owner.OwnerID
WHERE (((TenantPayment.TenantPaymentTypeID)=1) AND ((Owner.OwnerID)=5));