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

 

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.