I receive this error message when executing an SQL statement with a left join using more than 7 fields on each side of my == union. Here is my SQl expression:

SELECT D_TX,DATE_HEURE,tmpfol.CLEPERS,tmpfol.INST,tmpfol.TRANSIT,tmpfol.FOLIO,tmpfol.CD_SERV,tmpfol.NO_SERV,tmpfol.DTDETECTIO,tmpfol.CDDETECTIO FROM tmpfol LEFT JOIN ResDetectionTnmApp B ON tmpfol.clepers+tmpfol.inst+tmpfol.transit+tmpfol.folio+tmpfol.cd_serv+tmpfol.no_serv+dtos(tmpfol.dtDetectio)+tmpfol.cddetectio ==B.clepers+B.inst+B.transit+B.folio+B.cd_serv+B.no_serv+dtos(B.dtDetectio)+B.cddetectio WHERE .T. INTO TABLE c:\systoo\TEMP\52114621

I found that if I remove one of the field (any one) on each side, my SQl statement works fine. But from the moment I use more than 7 fields on each side I get the error. WHY??? Is there any maximum number of field that we can use in a join statement???

The table I use have about 10 record each, and the amount of memory available on my system is large enough (24 MB Ram available).

Thanks,