Lextree Simply the best software for managing legal entities and documents.
The Berkman Letter Practical analysis and commentary for business, law, and more.

I need to return a value from my database from using a row and column call.

Using flask SQLAlchemy and SQLite I have a database for a game. In this game I need to combine 2 elements to make a third. the first element comes from the column Main and the second is the name of a column where, in that row of main, the final element sits. So...

main | fire | water | air | earth
fire | null | smoke | inferno | magma

I can't seem to figure out the correct get request call to access the fire row let alone combine it with the water column to get smoke.