Hello Everybody
I need a relation between 2 tables with a common field an a constant.
SQL would be:
… from tab1 join tab2 on tab1.xyz = tab2.xyz and tab2.xxx = ‘MYCONSTANT’
How to do this in Servoy
Best regards
Albert
Hello Everybody
I need a relation between 2 tables with a common field an a constant.
SQL would be:
… from tab1 join tab2 on tab1.xyz = tab2.xyz and tab2.xxx = ‘MYCONSTANT’
How to do this in Servoy
Best regards
Albert
Hi Albert,
Just define a global variable with a default value and use that global on the left side of your relationship definition.