This is off the top of my head, but something similar should work in TQL: from area.county as country where country.countyid NOT IN (select subCounty.countryid from edition join subCounty where edition.id = :id)
You can do sub selects within IN statements, so this should work: http://docs.transfer-orm.com/wiki/Transfer_Query_Language.cfm#Where_statement_with_an_IN_statement Mark On Sat, Mar 14, 2009 at 10:25 AM, David Mineer <[email protected]> wrote: > 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. > > > > -- E: [email protected] W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
