question

table1 tbl_ItemCreation:(itemCreation_id primary key and autogenerated) Item_Name varchar(50), Item_Code varchar(50), Group_Name varchar(50), UnderGroup varchar(50), Unit_Name varchar(50), table 2 tbl_ItemGroup(itemGroup_id primary key and autogenerated) Group_Name varchar(50), Chbox_Val varchar(50), UnderGroup varchar(50), Comments varchar(50) table 3 tbl_UnitCreation:(Unit_id primary key and autogenerated) Unit_Name varchar(50), Unit_Abbreviation varchar(50), Unit_type varchar(50) these are my 3 tables.and id of each table is autogenerated. i want to insert group_name,undergroup from table 2 i.e tbl_ItemGroup into table 1 i.e tbl_ItemCreation. also unit_name from table 3 i.e tbl_UnitCreation into table 1 i.e tbl_ItemCreation. i am confused over table 1 i.e tbl_itemCreation that should i use foreign key or not? and how. also exactly which method to use for this. i tried this by using joins. INSERT INTO tbl_ItemCreation SELECT @Item_Name,@Item_Code,t1.Group_Name,t1.underGroup ,t2.unit_Name,@Comments1,t1.ItemGroup_Id FROM tbl_ItemGroup t1 Inner JOIN tbl_ItemCreation t3 on t1.ItemGroup_Id=t3.ItemCreation_Id inner join tbl_UnitCreation t2 on t3.ItemCreation_Id=t2.Unit_Id it is not producing error.but not giving expected result also. m i doing wrong?