If you are looking for simplicity in retrieving the data then SQL SERVER is best
Offcourse, performance of query is purely depends on how you fine tune the database and how you write your query
For example, below query will definitely be slow -
select * from table1 t1 where t1.Id in (select t2.id from table2)
but If I fine tune the query as shown below then it will run faster
select distinct t1.* from table1 t1 INNER JOIN table2 t2 ON t1.id=t2.id