Urgent Help - SQL Statement..

hai everybody,

i need ur help in writing a SQL statement..

i have 2 tables say

CATEGORY

cat_idcat_name

B001IT

B002Accounts

B003Clerk

SUB CATEGORY

sub_cat_idsub_cat_namecat_id

S001 programmingB001

S002 Admin B001,B002

S003 HRB001,B002,B003

i want to display one as liek ths

sub_cat_namecat_name

ProgrammingIT

adminIT,Accounts

HRIT,Accounts,Clerk

how to write a qry for this..pl help..

thanx in advance

regards

koel

[560 byte] By [koel78] at [2007-9-26 3:12:10]