So not knowing exactly what it is you're attempting to accomplish here:
Between the two options you have posted as long as you're on a modern RDBMS it will interpret both in the same way meaning there should be no statistical difference on speed.
That being said, depending on what data you are trying to pull, it is faster to use an INNER JOIN than an OUTTER JOIN(LEFT JOIN).
An INNER JOIN of A and B gives the result of A intersect B(think inner part of a venn diagram).
An OUTER JOIN of A and B gives the result of A union B(think outer part of a venn diagram).
INNER JOIN gives the intersection of the two tables(the two rows in common):
SELECT * FROM a INNER JOIN b ON a.a = b.b;
SELECT a.*,b.* FROM a,b WHERE a.a = b.b;
a | b
--+--
3 | 3
4 | 4
- SELECT * FROM a INNER JOIN b ON a.a = b.b;
- SELECT a.*,b.* FROM a,b WHERE a.a = b.b;
- a | b
- --+--
- 3 | 3
- 4 | 4
LEFT OUTER JOIN will return ALL rows in A plus rows common to B.
SELECT * FROM a LEFT OUTER JOIN b ON a.a = b.b;
SELECT a.*,b.* FROM a,b WHERE a.a = b.b(+);
a | b
--+-----
1 | null
2 | null
3 | 3
4 | 4
- SELECT * FROM a LEFT OUTER JOIN b ON a.a = b.b;
- SELECT a.*,b.* FROM a,b WHERE a.a = b.b(+);
- a | b
- --+-----
- 1 | null
- 2 | null
- 3 | 3
- 4 | 4
As one other note, a FULL OUTER JOIN will return ALL rows from both tables. Rows not common will be NULL for the corresponding table.
Long story short, if you are using table A to locate records in table B, use an INNER JOIN it is far more efficient. This is the vast majority of usage.