Rhino wrote: <snip>
The other thing that strikes me as a possible problem is the '&&' operator in the last join. I mostly use DB2 but it doesn't have this operator so I'm not completely sure what '&&' will do in a MySQL join. (I am familiar with the '&&' operator in programming languages, like Java, I've just never seen it used in joins before.) You might get a better result if you didn't use the '&&' operator and added another join for the Field_Lookup table.
Rhino
&& is a synonym for AND. See <http://dev.mysql.com/doc/mysql/en/Logical_Operators.html>.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
