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
Jump to PostPresumably 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
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_idThanks to all
Solved my problem :)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.