EJB3 NamedQuery using JDeveloper - selecting distinct specific fields

All,

According to the link http://java.sun.com/javaee/5/docs/tutorial/doc/index.html , chapter 27, the bnf for query language makes it look like I should be able to select individual fields in a named query:

@NamedQueries({@NamedQuery(name="findAllManufSoftwareVer", query="select distinct m.manufacturerId, m.softwareVersion from ManufacturerSoftwareVer m") })

However, JDeveloper won't select distinct fields names. For that matter, it won't even let me select specific fields at all. I can only select the entire object.I'm new to EJB3 and JDeveloper but know SQL very well. Is there a workaround for selecting distinct values from a table using EJB3?

Thanks!

[696 byte] By [LHalkapea] at [2007-11-15]