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

I discovered that when I attempted to issue the SQL directly to SQL Server. The VFP 5.0 view designer created the incorrect SQL by grouping the ON conditions together. Looks like a bug to me. I was finally able to get the view I needed by using the Create View command at the command line. However, after the view is created this way, I cannot use the view designer to edit it.