>>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


your first left outer join has no ON condition.