I expected the following three SELECT statements to be equivalent but they dont seem to be:
>CLEARSELECT [528] List '0' cleared. jsh rbk ~ -->SELECT ACCOUNT WITH CATEGORY EQ 1000 OR GE 1002 AND LE 9999 173218 Records selected >CLEARSELECT [528] List '0' cleared. jsh rbk ~ -->SELECT ACCOUNT WITH CATEGORY GE 1002 AND LE 9999 OR EQ 1000 102160 Records selected >CLEARSELECT [528] List '0' cleared. jsh rbk ~ -->SELECT ACCOUNT WITH CATEGORY (GE 1002 AND LE 9999) OR EQ 1000 173218 Records selected The second select seems to be ignoring the OR EQ 1000 as it is returning the same number of records with: >CLEARSELECT [528] List '0' cleared. jsh rbk ~ -->SELECT ACCOUNT WITH CATEGORY GE 1002 AND LE 9999 102160 Records selected I expect the brackets around (GE 1002 AND LE 9999) to be superfluous (only required to make the syntax clearer) but they seem to be having an impact on the number of records selected. Can someone please clarify. Regards, Marco. ___________________________________________________________ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
