Re: [RDBO] multi-object help sought

2006-09-11 Thread Jonathan Vanasco
thanks a ton. i guess i was thinking too much in sql terms-- i had to add a bunch more relationships as rose metadata > The Manager interface is designed to allow people to think only in > terms of > objects and relationships. If you think in SQL instead, you just > need to > know what SQL

Re: [RDBO] multi-object help sought

2006-09-11 Thread John Siracusa
On 9/11/06 4:04 AM, Jonathan Vanasco wrote: > i've spent the past 4hours trying to coerce some sql into Rose, and > its not working. perhaps someone here can point me in the right > direction. > > My SQL is such: > SELECT > account.* , > wants_item.*, > item.* > FROM > account2item_has has_item >

[RDBO] multi-object help sought

2006-09-11 Thread Jonathan Vanasco
i've spent the past 4hours trying to coerce some sql into Rose, and its not working. perhaps someone here can point me in the right direction. My SQL is such: SELECT account.* , wants_item.*, item.* FROM account2i