>sql server allows more than two outer joins, so it's not an sql limit, but an msquery limit. what was the error vfp gave you?

The error message I get: Connectivity Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Claimant_record' does not match with a table name or alias name used in the query.

Here is the SQL that the View Designer creates:
SELECT Claimant_record.claim_number, Claimant_record.claimant_name,;
Claimant_record.ss_number, Claimant_record.appt_type,;
Claimant_record.date_of_birth, Claimant_record.date_of_accident,;
Claimant_record.address_1, Claimant_record.address_2,;
Claimant_record.city, Claimant_record.state, Claimant_record.zip,;
Claimant_record.udds, Claimant_record.fund,;
Claimant_record.hrly_rt_at_toi, Claimant_record.claim_status,;
Claimant_record.claim_type, Claimant_record.weekly_wage,;
Claimant_record.wklywage_indicator, Claimant_record.part_of_body,;
Claimant_record.max_weekly_wage, Claimant_record.weekly_ttd_rt,;
Claimant_record.daily_ttd_rt, Claim_status.explanation;
FROM {oj jtr.claimant_record Claimant_record LEFT OUTER JOIN jtr.claim_status Claim_status;
LEFT OUTER JOIN jtr.claim_type Claim_type ;
ON Claimant_record.claim_type = Claim_type.code ;
ON Claimant_record.claim_status = Claim_status.code };
ORDER BY Claimant_record.claim_number