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" <
tionship between an order_id
in
| the order_id in the transaction response table. Please see my original
| 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: S
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
If I read right, this is a pretty basic join so I am assuming that you have
never done a join in your life.
select
distinct order.order_id
from
order
inner join
transaction_log on
order.order_id=transaction_log.order_id and
transaction_log.event_log_id <> 3
Brian.
-
