I want data of 2nd select statement instead of t2.order_data in my first select statement.
select t1.order_date,
t1.solution_id, t2.order_data, t2.price,
t3.description
from Orders t1, Order_Detail t2, Order_Status t3
where t1.order_id=t2.order_id and
t1.order_status_id = t3.order_status_id and t1.username in('xyz') and (t1.order_status_id=1 or t1.order_status_id=2)
SELECT ('data(//zip)')
AS Zip,order_data.query('data(//Category)')
As Category
FROM Order_Detail