I have a table ie already exist,& has a column 'cataegory'.Now i want to create a sub-category table that will be related to the first table.My problem is i can't be able to map.
for Ex-
first table
columns are-----id:int,categoryname:String
And it has a value 'java' under categoryname

i want to insert corejava,Servlet,Jsp,Struts..as subcategory in subcategory column of the second table

And that will related to java category of the first table.

Pls any one can ans!

Thanks

create category id in the main table (first tbl) and in subtable create subcategoryid and categoryid (two columns), now easly u can relate these two table with categoryid