Select records from one Table and Search in other table in SQL Server

Hi neda,

Please do as follow....

DECLARE @SearchTerm TABLE
(
	Id INT,
	Name VARCHAR(100)
)

DECLARE @House_info TABLE
(
	Id INT,
	[DESCRIPTION] VARCHAR(100)
)


INSERT INTO @SearchTerm VALUES (1,'India')
					,(2,'Paris')
					,(3,'Itally')
					,(4,'Economy')
					,(5,'Country')
					
INSERT INTO @House_info VALUES(1,'I love my India')
							,(2,'Here is paris and I love itally and I love parishilton')
							
SELECT * FROM @House_info WHERE ID IN(	
SELECT DISTINCT houseInfo.ID FROM @House_info houseInfo,@SearchTerm WHERE [DESCRIPTION] LIKE '%' + Name + '%')

Thanks and Regards,

Rk_Hirpara.