Art, Would suggest "Oracle8 -- A Beginner's Guide" by Oracle Press followed by "Oracle8 Complete Reference". Note, by the way, that the "join" is specified differently in Oracle as compared to MS Access -- you don't explicitly code the word JOIN in Oracle like you do in Access SQL, you just specify the linking key fields in the SQL WHERE clause. A "self join" is merely a table joined to a field in itself. Classic example is a list of employees and their managers, where employee and manager are columns in one table. HTH. Ben > -----Original Message----- > From: Art Broussard [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 11, 2000 11:47 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: Need help reducing the number of queries > > > > How would I do this if it is a standard parent/child table > > > with the fields cat_id, catname, parent_cat_id, parent_catname? > > > I think I now how the query would work but that is about it. > > > >I think you could do it by using a self-join and aliases for columns > drawn > >from one side of the join. > > > > > I can't find any good information on joins to understand the method you > are > taking about. Do you have any idea where I could get some info on > joins/self-joins for CF and Oracle? Can you give me an idea how a SQL > statement to do this would be written. I'm am still kind of new to this. > > Big Thanks > > Art > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > -------------------------------------------------------------------------- > ---- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
