On Thu, 05 Jun 2003 14:30:24 +0100, Moj Bordel wrote:
> 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.
>
Update test T, item I
set test.i_test=I.i_itemID
Where T.i_ID = I.i_itemID;
see mysql documentation section 6.4.5
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
