NAB SQL Data Source

[patricevincent]

Hi Support,
I'm creating a NAB Data Source by direct SQL.
All is good when i have only one table but when i had another in From clause, i get an error saying that "Expecting semicolon or end of input"
the sql code request works fine in green screen STRSQL

SELECT arcod, afcle FROM gc$$amc/xpart, gc$$amc/xfam WHERE afcle = argrp

I have searched but cannot find the answer ...
I have also moved to the last update of Valence.
Thanks for your help !
Patrice

[robert.swanson]

Hi Partrice,

We'll look into that. In the meantime, you should be able to get the desired result with this:

select arcod, afcle
from gc$$amc/xpart
inner join gc$$amc/xfam on afcle=argrp

[patricevincent]

Hi Robert,
Thanks for your reply and solution. This work fine.
I have a complex SQL with multiple Union/files and where clause that doesn't work in NAB that i have simplified for this example.
When you will have an update, i can test it on this complex SQL if you want.
Thanks for your help !
Patrice