-
Hi ,
Yes is correct you should use ‘exec’ instead of ‘select’ – however this is the syntax for the statement you need:
exec ... from select ... from ...
exec keyword | Reference | kdb+ and q documentation – Kdb+ and q documentation (kx.com)
If you have any questions please let me know,
Megan