how can i get data for all the value mentioned in condition 1

June 2, 2022 June 2, 2022 / 1 minute of reading

Yes, it’s possible – using a table valued constructor:

SELECT * 
FROM (VALUES ('T1'), ('T2'), ('T4'), ('T3')) AS [Keys]([Key])
LEFT JOIN [TAble] As T 
     ON [Key] = [Keys].[Key]

CLICK HERE to find out more related problems solutions.