List:General Discussion« Previous MessageNext Message »
From:Shawn Green Date:December 14 2009 4:51pm
Subject:Re: Join Statement
View as plain text  
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


Thread
Join StatementVictor Subervi14 Dec
  • Re: Join StatementPeter Brawley14 Dec
    • Re: Join StatementVictor Subervi14 Dec
      • Re: Join StatementShawn Green14 Dec
      • Re: Join StatementMark Goodge14 Dec
      • Re: Join StatementPeter Brawley14 Dec
        • Re: Join StatementVictor Subervi14 Dec
  • RE: Join StatementSteven Staples14 Dec