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.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]