Hi,

I have the following schema.

TABLE A
..NAME
TABLE B
..A.ID
..NAME
TABLE C
..A.ID
..NAME

I would like to select all TABLE A NAME and display in a panel as a list.
now I have a search box that searches as the user types.
I would like to search not only for TABLE.A.NAME, but if the user types TABLE.B.NAME OR TABLE.C.NAME , and if there is a B.NAME OR C.NAME for a particular A.NAME, I would like to display A.NAME.

How would you express that in hibernate query?

Thanks for the help