define by id from two table

Here I have created saq script that will help you out.

SQL

SELECT * FROM PersonTable
SELECT * FROM ProductTable
SELECT * FROM FruitTable

DECLARE @Name VARCHAR(200)
SET @Name = 'Rustam'

SELECT tbl.Id,tbl.Product FROM 
(
	 SELECT A.Product,  
		 Split.a.value('.', 'VARCHAR(100)') AS Id  
	 FROM  
	 (
		 SELECT Product,  
			 CAST ('<M>' + REPLACE(PersonId, ',', '</M><M>') + '</M>' AS XML) AS Data  
		 FROM  ProductTable
		 UNION ALL 
		 SELECT Product,  
			 CAST ('<M>' + REPLACE(PersontableId, ',', '</M><M>') + '</M>' AS XML) AS Data  
		 FROM  ProductTable
	 ) AS A CROSS APPLY Data.nodes ('/M') AS Split(a)
	 UNION
	SELECT A.Fruit,  
		 Split.a.value('.', 'VARCHAR(100)') AS Id  
	 FROM  
	 (
		 SELECT Fruit,  
			 CAST ('<M>' + REPLACE(PersonId, ',', '</M><M>') + '</M>' AS XML) AS Data  
		 FROM  FruitTable
		 UNION ALL 
		 SELECT Fruit,  
			 CAST ('<M>' + REPLACE(PersontableId, ',', '</M><M>') + '</M>' AS XML) AS Data  
		 FROM  FruitTable
	 ) AS A CROSS APPLY Data.nodes ('/M') AS Split(a)
 ) as tbl 
 INNER JOIN PersonTable p
 ON  p.Id = tbl.Id
 WHERE p.Name = @Name