I want to know is there any alternative for union in mysql
i dont want to use union because this sql query i have to convert into hibernate hql query.
But hibernat hql doesn't support union.
can any one suggest alternative of union
Below is my query i want to use this query without union
select * from category where parent_id =236282
select * from category where parent_id in(select category_id from
category where parent_id=236282)