Comparing Query Accomplishment Speed By Using JOIN or not
I would recommend to use JOIN for the following reasons:


It is optimised especially if Index properly designed and also if query get complicated later on.
Easy to read &amp; understand, tidier code and one result-set
It is way the professionals do
select the only columns which are required not everything which could increase network traffic