I have this object <object name="edition" table="tblEdition" decorator="com.beans.edition">
<id name="id" column="editionid" type="numeric"/> <property name="description" type="string"/> <property name="constructiontype" type="string"/> <property name="price" type="numeric"/> <manytoone name="area" lazy="true"> <link to="area.area" column="areaid"/> </manytoone> <manytomany name="county" table="tblEditionLinkCounty" lazy="true"> <link to="subscription.edition" column="editionid"/> <link to="area.county" column="countyid"/> <collection type="array"> <order property="name" order="asc"/> </collection> </manytomany> </object> I want to do a subselect and find all counties that don't already have a record in the manytomany table. So normally it would be select * from tblCounty where countyid not IN (Select countyid from tblEditionlinkCounty) How can I do this. Can I make a reference to that linking table when I don't have adefined object for it in transfer.xml, only that many to many reference? -- David Mineer Jr --------------------- The critical ingredient is getting off your butt and doing something. It's as simple as that. A lot of people have ideas, but there are few who decide to do something about them now. Not tomorrow. Not next week. But today. The true entrepreneur is a doer. --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
