Rhino wrote:
----- Original Message ----- From: "Michael Stassen" <[EMAIL PROTECTED]>
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>.
Yeah, I saw that in the manual. Does it behave EXACTLY the same as the AND keyword? Or are there some subtle differences?
Rhino
The manual seems clear that they are synonyms. Did something lead you to expect differences?
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]