Hi All,

Today is my first day and this is my first post.

I am a new in Hibernate but i have already created POJO using JPA and i am able to insert,delete,get records.

Just i want to know what is best way for below mentioned query.

select q.quoteno,p.pono,v.vendor_name
from quote_det q,po_det p, vendor_det v
where q.quoteno=p.quoteno
and p.vendor_id=v.vendor_id

I have create 3 POJO for three tables

Is i have to create separate POJO or i can use existing PO

Please let me know how i can handle above query best way in terms of performance