Yes I can

And when I run the below query this works also,

update dt

set dt.quantity =a.as_qtesto-a.as_qteres

from openquery(mysqlapp,'select * from product')as dt

inner join TRACTOV15.dbo.f_artstock as a on

dt.model = a.ar_ref collate database_default

where a.de_no ='15'

and dt.quantity<>a.as_qtesto-a.as_qteres

the only difference between the 2 queries is

- first on is only between 2 tables (one in mssql and the second in mysql)

- second one is with 3 tables (one in mssql and 2 tables in mysql)

and the second difference is

- first query is an update of the stock so no digits behind the dot example : 5

- second query is an update of the price example: 15.25

the only thing that i didn't test at this moment is the mssql database works like 15,25 and i think the mysql database works with 15.25

I was still looking how to convert a 15,25 price to a 15.25 price

but I am not sure if this gives the problem