Important Notice - Forums is archived
To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.
good database example
I am trying to build a simple database view.
My idea is to fill 3 tables called;
JOB, JOBACTION and ACTION_TRANSACTIONS.
JOB is the main has 1 to many JOBACTIONS. JOBACTIONS has 1 to many ACTION_TRANSACTIONS.
When I select a JOB from the first table I want to see the corresponding JOBACTIONS in the second table ed.
But as simple as it look it isn't for me.
I did a try with FreeformQuery but this type cannot have a filter.
Then I tried the TableQuery and that results in an error 'Incorrect syntax near 'LIMIT'.'
I drives me crazy :-)
Who has a good working database example with a working filter.
Chris
I would also like to see some complete example with joins, detail tables, many-to-many etc. It's a puzzle... :(