> First off I want to thank you sooo much for the help. Second
> off, sorry for all of the question. ;-)
No need to thank or apologize. After all, that's what the list is here for!
> With that said. What do you think of this?
>
> Table name is:
> pcategory
>
> field names are:
> cat_id, cat_name, cat_parent_id, cat_parent_name
>
> This is my query
>
> SELECT
> t1.cat_id AS cat_id,
> t1.cat_name AS cat_name,
> t1.cat_parent_id AS cat_parent_id,
>
> t2.cat_id AS sub_cat_id,
> t2.cat_name AS sub_cat_name,
> t2.cat_parent_id AS cat_parent_id,
>
> t3.cat_id AS sub_sub_cat_id,
> t3.cat_name AS sub_sub_cat_name,
> t3.cat_parent_id AS sub_cat_parent_id,
>
> FROM
> pcategory t1,
> pcategory t2,
> pcategory t3
>
> WHERE
> t1.cat_id = 0
> AND
> t2.cat_parent_id = t1.cat_id
> AND
> t3.cat_parent_id = t2.cat_id
>
> ORDER BY
> t1.cat_name,
> t2.sub_cat_name,
> t3.sub_sub_cat_name
It looks good to me. Of course, you'll find out when you run it. You don't
even need CF to test this out; just run it from an interactive query
environment and see what you get.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
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.
