Q&A for professional and enthusiast programmers
with FindColumns as ( select 'Id' as Seek UNION select 'PostId' as Seek ), MyTables as ( select object_id as Tab, count(*) as ColCount from sys.columns inner join FindColumns on name = Seek group by object_id ) select * from sys.tables inner join MyTables on object_id = Tab where ColCount = (select count(*) from FindColumns)