://www.websitepulse.com/
-Original Message-
From: Charley L. Tiggs [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Saturday, December 29, 2001 01:04
Subject: Newbie trying to optimizing a join search
I'm new to mysql and have gotten most things to work satisfactorily thus
far. One
I'm new to mysql and have gotten most things to work satisfactorily thus
far. One of the things that is stumping me at the moment is how to
perform queries using joins and how to optimize them for speed.
the query is structured as follows:
SELECT products.return
FROM products,prodcat
WHERE