I have a table that contains catagories and sub-catagories. Looks like this.
CatID ParentID Cat_Name
Catid is the PK
The parent catagory default with a value of 0 in the ParentID column.
Sub-cats have the catid of the parent in the ParentID column.
Is it possible to create a query that will give me out put in the form of:
Doctors
OBGYN
Family Practitioner
Nurse
RN
Intern
At Home
The indents are here for clarity purposes
Running Mysql 3.23.53
Any ideas how to accomplish this???
Thanks
Keith
