I'd like to use the graphical SQL-design editor in the Dataset Query Dialog tab DIAGRAM.
I added two tables and joined them via drag'n'drop of one key field that is available in both tables. So far so good.
The SQL-Statement (tab Texts and Outline) is correct and works (... from tabA inner join tabB on tabA.key1 = tabB.key1)
Now I would like to add a second join requirement (... and tabA.key2 = tabB.key2) via graphical diagram-editor, but when I do this all tables in the diagram disappear and the outline-tab and text-tab have no FROM-part anymore.
Perhaps it's a bug (in Jaspersoft Studio 6.6.0 community ed. Win 64 bit), or did I do something wrong?