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... :(