t's a good point!

Mutuelle Mut ON Mut.iidmutuelle = R.iidmutuelle INNER JOIN PrixMut P ON E.nType 

Thank !


>>IN Fact the problem become from a another code
>>I try to build per programmation a complex sql command
>>

>>TEXT To oSql.cSql NOSHOW TEXTMERGE PRETEXT 15
>> << m.cSql1 >>
>> << m.cInner1 >>
>> << oSql.ccondit1 >>
>> << m.cSql2 >>
>> << m.cInner2 >>
>> << oSql.ccondit2 >>
>>  ORDER BY 3 , 1, 4 , 2 INTO CURSOR CrystalNew READWRITE
>> ENDTEXT
>>

>>
>>&oSql.cSql Give :
>>
>>

>>SELECT T.cnomteleph AS 'cNomRes' , D.nFacT, M.cmatricule, ...
>>

>>
>>
>>A error 16 "unrecognised command"...
>>
>>
>>Do you see something bad ?
>
>Won't the "m.", used as alias name, be confused with a memory variable? Try using some other alias. Other single-letter aliases might also cause confusion, because of special meanings they have.