List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:December 14 2009 5:04pm
Subject:Re: Join Statement
View as plain text  
Victor,

 > I beg to differ:
 > mysql> select SKU, Quantity, Name, Price, p.sizes,
 > p.colorsShadesNumbersShort from tem126080739853 t join products p on
 > t.ProdID-p.ID <http://t.prodid-p.id/>;

...on t.ProdID-p.ID... _subtracts_ the two IDs. To match them use '=' 
rather than '-'.

PB

-----

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:
>
> mysql> select SKU, Quantity, Name, Price, p.sizes,
> p.colorsShadesNumbersShort from tem126080739853 t join products p on
> t.ProdID-p.ID <http://t.prodid-p.id/>;
> Empty set (0.00 sec)
>
> mysql> select * from tem126080739853;
> +----+--------+----------+----
> ---------+--------------------------+
> | ID | ProdID | Quantity | sizes       | colorsShadesNumbersShort |
> +----+--------+----------+-------------+--------------------------+
> |  1 |      2 |        2 | Extra-small | navy-blue:CC7722         |
> +----+--------+----------+-------------+--------------------------+
> 1 row in set (0.00 sec)
> mysql> select SKU, Quantity, Name, Price, p.sizes,
> p.colorsShadesNumbersShort from tem126080739853 t join products p on
> t.ProdID-p.ID <http://t.prodid-p.id/>;
> Empty set (0.03 sec)
>
> mysql> select SKU, Quantity, Name, Price, t.sizes,
> t.colorsShadesNumbersShort from tem126080739853 t join products p on
> t.ProdID-p.ID <http://t.prodid-p.id/>;
> Empty set (0.00 sec)
>
> mysql> select ID, SKU, Name, Price from products;
> +----+----------+-------+--------+
> | ID | SKU      | Name  | Price  |
> +----+----------+-------+--------+
> |  2 | prodSKU1 | name1 | 555.22 |
> +----+----------+-------+--------+
> 1 row in set (0.00 sec)
>
> t.ProdID == 2
> p.ID == 2
> That's a match.
> So why does my select join fail?
> TIA,
> V
>
>   
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 8.5.427 / Virus Database: 270.14.107/2564 - Release Date: 12/14/09 07:37:00
>
>   

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