>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.
Hmm..I've found the opposite to be true. Anyway, JOIN is more ASNI SQL compliant.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer