Yes, you're both right.

Thanks




>Didn't you want

select *
>  from media_order
>  where id NOT IN
>    (select media_order
>       from media_order_detail)
>

?
>
>>First I ran:
>>
>>

>>select *
>>  from media_order
>>  where id = 3901733
>>
>>select *
>>  from media_order_detail
>>  where media_order = 3901733
>>

>>
>>which returned 1 record for the first query and 0 records for the second. So I then
>>ran this:
>>

>>select *
>>  from media_order_detail
>>  where media_order NOT IN
>>    (select id
>>       from media_order)
>>

>>
>>which returned no records.
>>
>>Anyone know what's wrong here?