Hi all,
I'm newbie on Hibenate and my problem is;

I have 2 main tables(TerminalTable,AirlineTable) and a sub table(TerminalAirlineBaseTable).
I want to use this sub table distincted with the select query as to airline.
Which criteria code should I write for resultList?


TerminalAirlineBaseTable
terminalID AirlineID
---------- ---------
1 2
1 2
1 2
2 4
2 4
2 4
. .
. .
. .
TerminalTable <... ... AirlineTable
ID Name ID Name
-- ----- -- -----
1 aaa 2 AEROXXX
2 bbb 4 AEROYYY
3 ccc 5 AEROZZZ


resultList(); : TerminalTable AirlineTable
aaa AEROXXX
bbb AEROYYY

thanks for help
jotun

I'm sorry about that I mean TerminalTable and AirlineTable not same table...

TerminalTable
ID Name
-- -----
1 aaa
2 bbb
3 ccc



AirlineTable
ID Name
-- -----
2 AEROXXX
4 AEROYYY
5 AEROZZZ


TerminalAirlineBaseTable
terminalID AirlineID
---------- ---------
1 2
1 2
1 2
2 4
2 4
2 4
. .
. .
. .


resultList(); :
TerminalTableAirlineTable
Name Name
------ -------
aaa AEROXXX
bbb AEROYYY

Thanks

I solve this problem;

Session session = getCurrentSession();
Criteria criteria = session.createCriteria(FidsEventParameter.class);

criteria.setProjection(Projections.distinct(Projections.projectionList().add(Projections.property("terminal", "terminal").add(Projections.property("airline","airline"))).setResultTransformer(new AliasToBeanResultTransformer(FidsEventParameter.class));

List allparameterList = criteria.list();
return allparameterList;

thanks...
Jotun