General information
Category:
Coding, syntax & commands
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only