I think You are Totaly Confused What Your are Trying to Do?????
aNy how If You Want To insert Data Into Table Trough Store Procedure
Here is A sample
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[SP_ADD_ROLE]
@RoleDesc nvarchar(50),
@Comments nvarchar(max),
@RcoUpdate as nvarchar(max),
@IsActive varchar(1),
@DateCreated date,
@IsDelete varchar(1),
@Result as nvarchar(50) output
AS
BEGIN
SET NOCOUNT ON;
insert into TBLCFGROLES (RoleDesc,Comments,RCOupdate,IsActive,DateCreated,IsDelete)
values (@RoleDesc,@Comments,@RcoUpdate,@IsActive,@DateCreated,@IsDelete)
SET @Result = N'Data Inserted Successfuly'
END
and If you want to Join Your Tables
here is a Sample Query
SELECT TBLEMP.Name, TBLEMP.FName, TBLEMP.Mobile, TBLMARITALSTATUS.MaritalStatusDesc, TBLCFGSEX.SexDecription,
TBLEMPSTATUS.EmpStatusDesc
FROM TBLEMP INNER JOIN
TBLCFGSEX ON TBLEMP.CfgSexId = TBLCFGSEX.CfgSexId INNER JOIN
TBLEMPSTATUS ON TBLEMP.StatusId = TBLEMPSTATUS.StatusId INNER JOIN
TBLMARITALSTATUS ON TBLEMP.MaritalStatusId = TBLMARITALSTATUS.MaritalStatusId