How can i do an update a column in a
table width the fields of another table
i would like to do the folowing query:
UPDATE enc_oper set estado = "N",
quant_prod = 1 * opera.quantidade whe
re encomenda = 20010004580 and posicao =
1 and opera.codigo = enc_prod.opera;
But i dont know how to get the value
from table opera. Can someone help me?
---------------------------------------------------------------------
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
