Try removing the parenthesis and changing the OR to an AND. The OR may be
killing your statement because you are using it between two "Not Equal to"
statements. ~Chad

On Tue, Feb 26, 2013 at 5:28 PM, Christian, Jessie <
[log in to unmask]> wrote:

> I am trying to perform an advanced query to find all photographs in our
> collection. The following query indicates the three departments I don’t
> want to include as well as the two object number strings I don’t want
> included. However, even when I play with AND/OR operators and parenthesis,
> I still get the error: *Incorrect syntax near the keyword ‘ORDER’*. Any
> ideas? ****
>
> ** **
>
> Thanks!****
>
> jessie****
>
> ** **
>
> [image: chrisjones.png]****
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
>  You will receive a confirmation that your subscription has been removed.
>

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.