You need to use native SQL queries, there is no support for UNION in EJB-QL/JPA-QL/HQL.
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