select * from vendor where id in (select top 2 id from vendor order by id desc) union all select * from labour where id in (select top 2 id from labour order by id desc) I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.