Thanks, that seemed the sensible way to me as well. I just didn't know
for sure if you could do that in a MySQL query for sure.
Thanks,
Ed
On Fri, 6 Feb 2004, John McCaskey wrote:
> Yes, I think the most straight forward way is to simply put in a series of
> grouped OR statements. See below.
Yes, I think the most straight forward way is to simply put in a series of
grouped OR statements. See below.
SELECT * from pages WHERE
changelog.agent = pages.agent AND
changelog.company = pages.company AND
changelog.magazine = pages.magazine AND
(
changelog.orig_id = pages.mls_1 OR
changelog.ori
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
