0

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

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by dre-logics
0

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 ;

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.