hi all,
i am using sqldeveloper 3.2
i hv four table like
table-a
visit_id number(10);
assign_id varchar2(100) values(f-0,s-1,s-2,s-3...,c-1,c-2...) but only f-0 is once and rest values are like s1,s-2 ...... ans c-1,c-2.... and actually s stand for section and these values 1,2 ..are section id in tableb
and similarly c stands for category and 1,2...are category_id in table c
table b
section_id varchar2(10) values(1,2,...........)
section name varchar2(10) values(x,y..........)
table c
category_id varchar2(10) values(1,2,...........)
category_name varchar2(10) values(x,y..........)
and table d
visit_id varchar2(10) values(1,2,...........)
visitor_name varchar2(10) values(x,y..........)
only relation is among four table is table a and table d (visit_id) but no relation with table c and table d
but i need out put like visit_id,visit_name ,section_name, category name
pls pls help me
Thanks
Damby