I have two databases:
data2 in two different servers (
I am trying to join two tables of my two databases in MySQL like this:
SELECT left(a.code,9) as fourn, SUM(b.price) as total FROM data1.product as a JOIN data2.my_items as b ON a.fourn = b.left(p_code)
and this is the error I get when I run the query in
SELECT command denied to user 'slave'@'' for table 'my_items'