Victor Subervi wrote:
> On Mon, Dec 14, 2009 at 12:37 PM, Peter Brawley <peter.brawley@stripped
>> wrote:
>
>> > ... 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?
> TIA,
> V
>
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
