Victor Subervi wrote:
> On Mon, Dec 14, 2009 at 12:37 PM, Peter Brawley <peter.brawley@stripped
>> > ... on t.ProdID-p.ID;
>> Your join clause subtracts the two IDs, so it's on IDs that differ, and
>> apparently there aren't any.
> I beg to differ:
> So why does my select join fail?
It fails because you aren't using = but are using - . Switch your query to
"... ON t.ProdID = p.ID"
and see if that works any better.
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN