union all returned table from loop

ALTER PROCEDURE [dbo].[qry_show_bids_for_thumbs_acc_by_text]
	@KEYWORDS VARCHAR(100)
AS
BEGIN
	SET NOCOUNT ON;
 
	DECLARE @KeyResults TABLE ( myKey varchar(50) )
 
	INSERT INTO @KeyResults (myKey)
	(select * from fnSplit(@KEYWORDS, ' '))
 
	DECLARE @myint int
	DECLARE @currKey varchar(50)
	DECLARE @myclause varchar(max)
 
	set @myint = 0
 
	while @myint <= (select count(*) from @KeyResults)
	begin
		set @currKey = (SELECT myKey FROM (SELECT Row_Number() OVER (ORDER BY myKey) as rowid, myKey FROM @KeyResults ) as a where rowid = @myint)
		set @myint=@myint+1
		
		SELECT        tbl_bids.bid_id
					, tbl_accessories.acc_name
					, tbl_accessories.acc_description
					, MAX(tbl_gallery.gallery_imageurl) AS FirstOfgallery_imageurl
					, MAX(tbl_gallery.gallery_alt) AS FirstOfgallery_alt
					, tbl_bids.bid_enddate
					, tbl_bids.bid_prodtype
					, tbl_bids.bid_minprice
		FROM	tbl_accessories WITH (NOLOCK) INNER JOIN 
				tbl_bids WITH (NOLOCK) ON tbl_accessories.acc_id = tbl_bids.bid_accid LEFT JOIN
				tbl_gallery WITH (NOLOCK) ON tbl_accessories.acc_id = tbl_gallery.gallery_accid
				WHERE tbl_accessories.acc_name LIKE '%' + @currKey + '%'
		GROUP BY  tbl_bids.bid_id
				, tbl_accessories.acc_name
				, tbl_accessories.acc_description
				, tbl_bids.bid_enddate
				, tbl_bids.bid_prodtype
				, tbl_bids.bid_minprice
		HAVING ((tbl_bids.bid_enddate>=getdate()) AND (tbl_bids.bid_prodtype='Other'))
	end
END