Joining a list of values with table rows in sql

Repost of StackOverflow answer

In Microsoft SQL Server 2008 or later you can use Table Value Constructor

SELECT v.valueId, m.name 
FROM (VALUES (1), (2), (3), (4), (5)) v(valueId)
LEFT JOIN otherTable m ON m.id = v.valueId