subquery VS joining Table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bobby (bobby.saputra_at_epselindo.com)
Date: 08/20/04


Date: Fri, 20 Aug 2004 13:31:27 +0700

Hi....

I see that we can get same data if we use subquery or joining table(ex:
inner/right/left join).

my Question is:
When to use subquery and when to use "join" ? and the plus minus?
Performance? Best Practice?

Thanks....