I wanna get a syntax which add some informations into a table.
Syntax must collect informations from 2 tables and adding them into third table.
Let me explain interests:
Database account, table account: columns marked: id, login
Database player, table player: columns marked: account_id, name
Database common, table gmlist: columns marked: mAccount, mName
insert into gmlist ( mAccount, mName ) select login, name from account.account a inner join player.player p on p.account_id=a.id
might do the trick. I am still not certain about your columns.