Hello everyone,
I would like to know how to retrieve certain data from the DB with respect to entity relationship. Consider the following SQL statement.
"Select i.id, i.name, i.description, i.colour, i.size, o.oid, o.date, o.quantity from Item i, Order o"
Or a very complex SQL statement using JOIN in tables.
The Order entity is a 1 to many relation to Item - an order can have many items. But when retrieving the details from order, I want to see certain data from the Order table as stated above, but not all the data from Order. How do I achieve this in EJB3 query?
Thanks
eve
_________________________________________________________________
Get free emoticon packs and customisation from Windows Live.
http://www.pimpmylive.co.uk