Re: [HACKERS] Weird behaviour with subquery

2004-03-22 Thread Christopher Kings-Lynne
Doh - I think I understand now why this is normal behavior - sorry! Chris Christopher Kings-Lynne wrote: What's going on here: usa=> select user_id from users_users where joindate >= '2004-03-09'; ERROR: column "user_id" does not exist usa=> select * from shop_orders where user_id in (select u

[HACKERS] Weird behaviour with subquery

2004-03-22 Thread Christopher Kings-Lynne
What's going on here: usa=> select user_id from users_users where joindate >= '2004-03-09'; ERROR: column "user_id" does not exist usa=> select * from shop_orders where user_id in (select user_id from users_users where joindate >= '2004-03-09'); [waits and waits and waits...have to cancel] ^CCan