SELECT aus 2 Tabellen - mysql, select, multiple-tables

Meine Tische:

Tabelle 1

id|name_transfer|id_account_from|value_from|id_account_to|value_to
------------------------------------------------------------------
1 |transfer1    |1              |1000      |2            |1000

Tabelle 2

id|name_account|
----------------
1 |account1    |
2 |account2    |

Wie schreibe ich die Abfrage, dass ich das gegeben habe:

transfer1|account1|1000|account2|1000

Antworten:

5 für die Antwort № 1
select
t1.name_transfer,
t2a.name_account as name_account_from,
t1.value_from,
t2b.name_account as  name_account_to,
t1.value_to
from
table1 t1
inner join table2 t2a on t2a.id = t1.id_account_from
inner join table2 t2b on t2b.id = t1.id_account_to
where
t1.id = 1