John,
The use of is a logical and, the normal SQL keyword
would be AND.
As in:
WHERE `productid` = 173846 AND `variantid` = 73130
AND `type` = 's'
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
I have a query that is giving me fits, but I can't find where there
error is. I know its one of those things that I'll slap myself in the
forehead for not seeing, but after a half an hour, it's all a blur. ;)
If someone can spot it, I'd be most grateful.
REPLACE INTO product_dimensions SET
[mailto:jnic...@kegworks.com]
Sent: Tuesday, January 26, 2010 12:54 PM
To: mysql@lists.mysql.com
Subject: Need an extra pair of eyes
I have a query that is giving me fits, but I can't find where there
error is. I know its one of those things that I'll slap myself in the
forehead for not seeing