What is the deal between making table joins and just using the where clause to combine information from multiple tables based on common fields. The where clause seems to be extremly faster than the join clause.

Thanks.