self related table problem

Hi all
I have following table structure

pk_cat_id(int)     cat_name(varchar)     cat_desc(text)    fk_cat_id(int)

table is self related as one to many

i want to select cat_name, cat_desc and parent_cat_name()
i.e.
from fk_cat_id, how i can get cat_name

Contributors

Replies

2 Hours

Discussion Span

1 Year Ago

Last Updated

Views

Question
Answered

Junior Poster

155 posts since Mar 2011

Reputation Points: 29

Solved Threads: 10

Skill Endorsements: 0

Presumably it's

select child.cat_name, child.cat_desc, parent.cat_name
from mytable child, mytable parent
where child.pk_cat_id = parent.fk_cat_id

Nearly a Posting Virtuoso

1,297 posts since Oct 2010

Reputation Points: 321

Solved Threads: 270

Skill Endorsements: 8

Question Answered as of 1 Year Ago by smantscheff

Thanks to all
Solved my problem :)

Junior Poster

155 posts since Mar 2011

Reputation Points: 29

Solved Threads: 10

Skill Endorsements: 0

This question has already been solved: Start a new discussion instead

You