List:General Discussion« Previous MessageNext Message »
From:Vladislav Vorobiev Date:January 2 2008 1:09pm
Subject:Re: order by in query
View as plain text  
2008/1/2, Edward Kay <edward@stripped>:
>
> >
> > 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.org
Thread
order by in queryVladislav Vorobiev2 Jan
  • RE: order by in queryEdward Kay2 Jan
    • Re: order by in queryVladislav Vorobiev2 Jan