Hi all,
this is my first post so please be kind if I'm not clear.

Here is my problem

I have two tables:

1) Journey
2) Orders

That I have mapped correctly.

Question 1:

I want to map Journey subclass (call this subJour) with only a subset of Journey fields

how to do this???(and before saying it's really easy read the following question)

Question 2

I have a query on Orders (call this ordOfJour) that gives me back some orders.
this query uses where clause and group by

is it possible to have results of this query as objects with a mapping class that takes query parameters to initialize?

Question 2.b

if the above one is possible,
how I map this to make possible calls such as subJour.getOrdOfJour() ???

it's a bit complex but I think someone out there has the solution or can put me on the right way

thanx in advance,
Sasà