DECLARE @temp int(20)
SET @temp  = '''select emp_id from employees'''

select emp.emp_id,emp.name,team.team_name from employees emp join team team on emp.team_id=team.id and emp.id in (@temp)