The result of the query below is:
Team1 Team2 Goals_T1 Goals_T2
Brasile Croazia 0 2
SELECT teamh.name as Team1,
teamg.name as Team2,
game.g_teams_score as Goals_T1,
game.h_teams_score as Goasl_t2
FROM iew1r_sportspredictions_games game
left join iew1r_sportspredictions_teams teamh
on game.h_teams_id = teamh.id
left join iew1r_sportspredictions_teams teamg
on game.g_teams_id = teamg.id
How can I reproduce it in Fabrik?
I did following:
---------
I created a new List (connection to iew1r_sportspredictions_games table)
Join Type: Left
From: iew1r_sportspredictions_games / to:iew1r_sportspredictions_teams
From column: h_teams_id / To column: id
Join Type: Left
From: iew1r_sportspredictions_games / to:iew1r_sportspredictions_teams /
From column: g_teams_id / To column: id
Then I selected elements I want to be displayed
---------
The result is not like expected. Only one Join Table is visible.
Team1 Team2 Goals_T1 Goals_T2
Brasile Brasile 0 2
Thanks for support
Team1 Team2 Goals_T1 Goals_T2
Brasile Croazia 0 2
SELECT teamh.name as Team1,
teamg.name as Team2,
game.g_teams_score as Goals_T1,
game.h_teams_score as Goasl_t2
FROM iew1r_sportspredictions_games game
left join iew1r_sportspredictions_teams teamh
on game.h_teams_id = teamh.id
left join iew1r_sportspredictions_teams teamg
on game.g_teams_id = teamg.id
How can I reproduce it in Fabrik?
I did following:
---------
I created a new List (connection to iew1r_sportspredictions_games table)
Join Type: Left
From: iew1r_sportspredictions_games / to:iew1r_sportspredictions_teams
From column: h_teams_id / To column: id
Join Type: Left
From: iew1r_sportspredictions_games / to:iew1r_sportspredictions_teams /
From column: g_teams_id / To column: id
Then I selected elements I want to be displayed
---------
The result is not like expected. Only one Join Table is visible.
Team1 Team2 Goals_T1 Goals_T2
Brasile Brasile 0 2
Thanks for support