from sql query to mysql equivalent -

please, have query in sql

select sum(lhd.sasih)-sum(lhd.sasid) sasi,lhd.kartllg kartllg e2013..levizjehd lhd,supersick_db..produkt prod  lhd.kartllg=prod.kodfinance group lhd.kartllg 

i need write it's equivalent in mysql... error:

invalid object name 'e2013..levizjehd'. 

what need translate in mysql query, don't know .. stand in sql. i'd appreciate please.

how connect

$host="192.168.10.250\\f501"; $uid="sa"; $passval=""; $database="supersick_db"; $objconnect = odbc_connect("driver={sql server};server=$host;database=$database;",$uid, $passval ) or die("connection not established"); 

thanks!

seems referring database name. 'e2013' 1 db , 'supersick_db' another. first contains 'levizjeh' table other 1 'produkt' table.

if have both tables inside same mysql can skip name , .. altogether.

select sum(lhd.sasih)-sum(lhd.sasid) sasi, lhd.kartllg kartllg levizjehd lhd, produkt prod lhd.kartllg = prod.kodfinance group lhd.kartllg 

you can improve query this:

select sum(lhd.sasih)-sum(lhd.sasid) sasi, lhd.kartllg kartllg levizjehd lhd inner join produkt prod on lhd.kartllg = prod.kodfinance group lhd.kartllg