Member Avatar for baig772

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

  • 2 Contributors
  • 2 Replies
  • 107 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by baig772
Member Avatar for smantscheff

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
commented: explanatory :) +3
Member Avatar for baig772

Thanks to all
Solved my problem :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.