Is there any Sqlite select query for getting two tables result?
Try double join
as below
select T.MD,T.MT,P1.Name as PlayerName1, P2.Name as playername2 from Timings Tjoin Players P1 on P1.Id = T.Team1join Players P2 on P2.Id = T.Team2
Try double join
as below
select T.MD,T.MT,P1.Name as PlayerName1, P2.Name as playername2 from Timings Tjoin Players P1 on P1.Id = T.Team1join Players P2 on P2.Id = T.Team2