SQLITE - How can i create nested tables/Access Child table from Parent table

Here is my problem - I generate one big table called Main - for general data and a lot of smaller ones which have detailed statistics.

I want to do something like that In Main every row is like that:

Team1 - Team2 - Score - Details

and Details should be a table with 10 rows and few columns.

Details is different table for each row in Main(match0, match1 etc.)

I tried to do it like that:

to each row in Details table I add a foreign key pointing to specific row in Main table - but how can I access rows in Child table from Parent table?

If it's possible it would solve my problem. Or is there simpler way to do it?

Thanks for reply!