g.orig_id = pages.mls_11 OR
> changelog.orig_id = pages.mls_12
> )
>
> John A. McCaskey
>
>
>
> -Original Message-
> From: Ed Curtis [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 06, 2004 10:20 AM
> To: [EMAIL PROTECTED]
> Subject: Query matching
>
OR
changelog.orig_id = pages.mls_11 OR
changelog.orig_id = pages.mls_12
)
John A. McCaskey
-Original Message-
From: Ed Curtis [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 10:20 AM
To: [EMAIL PROTECTED]
Subject: Query matching
I've been challenged to write a mat
From: Ed Curtis [mailto:[EMAIL PROTECTED]
> I've been challenged to write a matching query in a project
> and do not know how to handle a part of it. The criteria are
> as follows:
>
> SELECT * from pages WHERE
>
> changelog.agent = pages.agent AND
> changelog.company = pages.company AND
> ch
I've been challenged to write a matching query in a project and do not
know how to handle a part of it. The criteria are as follows:
SELECT * from pages WHERE
changelog.agent = pages.agent AND
changelog.company = pages.company AND
changelog.magazine = pages.magazine
Now for the challenging par
At 23:20 -0400 7/2/02, Tac wrote:
>I have a table with a "state" field, and often I want to get only records
>matching those states, ordered. This simple query
>
> Select * from my_table where state='NJ' order by table_id DESC
>
>is relatively slow because of the order by clause (where there
I have a table with a "state" field, and often I want to get only records
matching those states, ordered. This simple query
Select * from my_table where state='NJ' order by table_id DESC
is relatively slow because of the order by clause (where there are a lot of
matching records). I've tri
