Sender: |
|
Date: |
Tue, 26 Feb 2013 17:52:49 -0500 |
Reply-To: |
|
Subject: |
|
MIME-Version: |
1.0 |
Message-ID: |
|
In-Reply-To: |
|
Content-Type: |
multipart/related; boundary=e89a8f22c381592e1504d6a884b9 |
From: |
|
Parts/Attachments: |
|
|
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.
|
|
|