dOES TkbmMemSQL support JOIN

[Johan De Beuckeleer]

Hello,

I would like to run this query in TkbmMemSQL, but I get a message JOIN is not supported.

In the source code I see this remark:
// 7.10.00 Merged kbmSQL into kbmMemTable. Please see history in kbmMemTable.pas for further history info.

I create 2 KbmMemtables (imported from Advantage DataBase Server) and want to run this query to join them:
ImportSql :=
‘SELECT AC_ACCOUN.AID, AC_ACCOUN.AISTITLE, AC_ACCOUN.HEADING1, AC_ACCOUN.HEADING2, AC_ACCOUN.AISSUMMARY, AC_ACCOUN.ACATCOMM, AC_ACCOUN.AISMATCH, ‘
+ ‘ AC_ACCOUN.PRCPRIVATE, AC_VAT.VDEDUC, AC_ACCOUN.AVATNCMP ‘
+ ‘ FROM AC_ACCOUN ‘
+ ‘ LEFT JOIN AC_VAT ON AC_VAT.VNAT1 = AC_ACCOUN.AVATNNAT1 AND AC_VAT.VNAT2=AC_ACCOUN.AVATNNAT2 AND AC_VAT.VCOMPUTE = AC_ACCOUN.AVATNCMP’;

How can I run the Query in kbmMemTable?

Regards
Johan

[Author]

Posts