> > 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.
