MySQL
Subject: Re: SQL JOIN Challenge - Help Please
Actually, you should be able to get the data in one query: in general,
any time you are doing a restriction on some value being in a set of
values (such as order_id not in ) you
can rewrite the query using LEFT OUTER JOIN's. In this case, th
action_log where order_id not in ({id list})
>
> The list could be pretty big I guess.
>
> Brian.
>
> - Original Message -
> From: "Paul Maine" <[EMAIL PROTECTED]>
> To: "Brian Moon" <[EMAIL PROTECTED]>; "MySQL MySQL" <
ent: Sunday, August 25, 2002 7:02 AM
Subject: RE: SQL JOIN Challenge - Help Please
| This is deceptively simple, and I very much appreciate your suggestion -
but
| it doesn't work. Your suggestion still returns records that I should not
| see. Once again, there is a one to many rela
Paul,
Based on your original post, I'd have to agree with Brian. That query
should work. In fact, something as simple as this should work too:
select
order.order_id
from
order
,transaction_log
where
order.order_id = transaction_log.order_id
an
ginal
email.
Thank you
Paul
sql query
-Original Message-
From: Brian Moon [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 25, 2002 12:11 AM
To: Paul Maine; MySQL MySQL
Subject: Re: SQL JOIN Challenge - Help Please
If I read right, this is a pretty basic join so I am assuming that you
Brian.
- Original Message -
From: "Paul Maine" <[EMAIL PROTECTED]>
To: "MySQL MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, August 24, 2002 7:31 PM
Subject: SQL JOIN Challenge - Help Please
| I have an order table and a transaction log table. The order table h