Hi;
I have the following:
mysql> select SKU, Quantity, Name, Price, p.sizes,
p.colorsShadesNumbersShort from tem126080739853 t join products p on
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;
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;
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)
So I'm at a loss as to why the above select join statement fails. Please
advise.
TIA,
Victor
