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?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people