Subquery v/s inner join in sql server
The SQL Server query analyzer is smart enough to understand that these queries are identical (given that item_ID is unique in EMR.tblFavourites for a certain doctorID/favType pair). 

They should yield exactly the same execution plan, and thus they are equal in terms of performance. I would prefer second variant though...