I use Visual Basic 8.0 and MySQL 5.0

select * from rental,stock where rental.Article=stock.Article ;

This gives the following result:

stock.article stock.stock rental.article rental.rent
1000 100 1000 15
2000 150 2000 25


Update stock set stock.stock=stock.stock-rental.rent where rental.Article=stock.Article ;

This gives the following result:

Unknown column rental.Article lin 'where clause' erro 1054
Who can help me solve this error


Thanks in advance
Andre

i have find the solution my self , it was simple, forgot table Rental

Update stock,rental set stock.stock=stock.stock-rental.rent where rental.Article=stock.Article ;