Victor Subervi wrote:
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:
...
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org