i have made a stored procedure in which two tables and ID field is provided as input and the result is used to fill a combo in a form .when i execute it i get the follwing error: Incorrect syntax near 'MAST_STORE'. my procedure is here .Kindly anyone tell me wats wrong with it.there is a small mistake that i hvnt found yet. ALTER PROCEDURE [dbo].[mp_LoadPartCombo] -- Add the parameters for the stored procedure here @table1 as varchar(max)=MAST_PART, @table2 as varchar(max)=MAST_STORE , @IdCol as varchar(max)=StoreID AS BEGIN declare @select as varchar(Max); set @select = '(select * from ' + @table1 + ' innerjoin ' + @table2 + ' on ' + @table1 + '.' + @IdCol + ' = ' + @table2 + '.'+@IdCol + ')' --print (@select) exec (@select)

i hv solved it .i used join instead of innerjoin and problem wz solved