Re: order by in query

2008/1/2, Edward Kay <[EMAIL PROTECTED]>: > > > > > Hello i use this query: > > > > select i.item_id > > from orders o > > INNER JOIN item i ON i.nr=i.nr > > Should the line above not be > ... ON i.nr = o.nr ? Autch. thank you! It works now. -- Best Regards Vlad Vorobiev http://www.mymir.or

RE: order by in query

> > Hello i use this query: > > select i.item_id > from orders o > INNER JOIN item i ON i.nr=i.nr Should the line above not be ... ON i.nr = o.nr ? > INNER JOIN user_cart u ON u.nr=i.nr > where (i.count !=0 or i.count!=NULL) and i.isactive=1 and i.kolWo>0 > order by i.count DESC > LIMIT 5 >