database union in ejb3

[kaviarasu]

Hi i want to write a query as i had given below in ejb3
select field_1,field_2 from table1 t1,table2 t2 where t1.pk=t2.fk
union
select field_1,field_2 from table1 t1,table3 t3 where t1.pk=t3.fk

where
Table 1 is the entity with PK as a primary key.
Table 2 is using PK as a foreign key.
Table 3 is using PK as a foreign key.
Tables 2 and 3 are only related through that foreign key and contain dissimilar data that relates to Table 1.
The relationship between table 1 & 2 and 1 & 3 are both one to many.

can any onr suggest me how to achive this

my entity bean is

@Entity
@Table(name = "TBL_REVIEWS")


@SecondaryTables({
 @SecondaryTable(name="TBL_USER_REVIEWS",
 pkJoinColumns={@PrimaryKeyJoinColumn (name="REVIEW_ENTRY_ID")}),
 @SecondaryTable(name="TBL_COMMENTS",
 pkJoinColumns={@PrimaryKeyJoinColumn (name="REVIEW_ENTRY_ID")})
})

can any one help me soon
thanks
regards
Kaviarasu

[christian.bauer]

You need to use native SQL queries, there is no support for UNION in EJB-QL/JPA-QL/HQL.

[kaviarasu]

thank u
here i want to pull all the data from table 2 and table 3 which match the primary key from table 1
can u say any suggestion
thank u for ur reply
im using oracle as back end and jboss-seam-1.2.1.GA and xhtml as front end
can u give any suggestion to attain this result
thank you
regards
kaviarasu