On 9/16/06, Tim Hoff <[EMAIL PROTECTED]> wrote: > Or, you could do it this way: > > SELECT Lenders.LenderID, Lenders.LenderName, > Locations.LocationID, Locations.LocationName, > Contacts.ContactID, Contacts.ContactName > FROM Lenders, Locations, Contacts > WHERE Lenders.LenderID = Locations.LenderID > AND Locations.LocationID = Contacts.LocationID > FOR XML AUTO
or try ben's "Building Flex Tree MXML From ColdFusion Queries" http://www.forta.com/blog/index.cfm/2006/8/24/Building-Flex-Tree-MXML-From-ColdFusion-Queries -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
