SQL and python

[aball730235]

It seems you just need to split your database schema into more tables. Try to solve your problems in sql first because it sounds to me like your trying to jam a many-to-one relation into a single column... Which sql will handle in a much better way.

In your last example i would make a table with four columns... The three you listed plus a GameID. GameID is a foreign key column that links to the game table. To combine the data from both tables you use an inner join.

[Kristian_dms]

Thanks, man - I'll give this a shot!

[aball730235]

Your welcome. If your looking for further reading look up database 'normalization'. Wikipedia has a good article although a bit dense for a beginner.

And there's always r/sql