Hi,Is it possible to join table in Advance SQL? If so then how make it an output? I tried to add two structure but it not work.Appreciate all your input in advance
In your first screenshot you had two entities in the Output Entites / Structures folder. Then you replaced them with one structure. Roll this back to the entities and make sure the are the same ones in the same order as you wrote in SELECT.
Hi Jordan,
You have to specify your output entities and/or attributes after SELECT, separated by ",". If should match your output entities and structures list.
SELECT {Employee..1}.*, {Employee...2}.* FROM ...
I tried but It gives me errorwhen testing
Add the same entities you're using in SELECT to the output list.
yes I used two entities separated by "," on Selectif that's what you mean?also tried adding it in FROM
Thanks everyoneWe used each other ideas to solve this inquiry. Appreciate you both.