From: Victor Subervi Date: December 14 2009 5:50pm Subject: Re: Join Statement List-Archive: http://lists.mysql.com/mysql/219740 Message-Id: <4dc0cfea0912140950j2b1c64ddi9975d588f137248b@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=002354471014c6786d047ab3e725 --002354471014c6786d047ab3e725 Content-Type: text/plain; charset=ISO-8859-1 On Mon, Dec 14, 2009 at 1:04 PM, Peter Brawley wrote: > ...on t.ProdID-p.ID... _subtracts_ the two IDs. To match them use '=' > rather than '-'. > Thank you for all of you that caught that. V --002354471014c6786d047ab3e725--