Hi All,
With a database that contains tables PetInv and Purchases:
mysql> update PetInv
-> set PetInv.Qty = PetInv.Qty + Purchases.Qty
-> where PetInv.ItemNo = Purchases.ItemNo;
ERROR 1109: Unknown table 'Purchases' in where clause
As you can see I'm trying to add purchase quantities to existing quantities,
but obviously I'm not doing it right. Any ideas?
TIA,
Jim
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
