On Mon, Dec 14, 2009 at 12:37 PM, Peter Brawley <peter.braw...@earthlink.net > 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
