Information générale
Catégorie:
Codage, syntaxe et commandes
>> 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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement