Re: SQL order of operations question

When in doubt, ALWAYS use parens. Otherwise you might try using the "set explain" option. The output plan will provide parens telling you how Informix thinks that the grouping should be executed. Any parens that you provide in the SQL statement will override this. -d At 09:52 AM 10/3/97 -0500, Bill Ennis wrote: }Hi, } }What are the order of operations enforced by the Informix SQL }parser with regards to AND/OR in a WHERE clause. Is there a }precedence or is it just left to right? } }Thanks, }Bill } }