> Unknown table 'item' in where clause" > while of course table 'items' exists...
Well... which table exists, 'item' or 'items?' Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Moj Bordel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, 05 June, 2003 09:30 Subject: Why is this not possible??? Hello, I'm not really sure (I'm by no means an expert) but shouldn't this be possible? UPDATE test set i_test=item.i_itemID WHERE test.i_ID=item.i_itemID; I'm getting this reply: "MySQL said: Unknown table 'item' in where clause" while of course table 'items' exists... I use mySQL service at my webhosting, so I don't have the control over the database. Thanx Marc __________________________________________________ Yahoo! Plus For a better Internet experience http://www.yahoo.co.uk/btoffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
