my sql database with many tables : i want to create some number of tables (lets say as sub tables) and make all sub tables to point to one main table. If i query with main table i should be able get details from all sub tables together or even from individual subtable table details. I am using python interface for querying.

This is my requirement. Kindly suggest me some ideas. Thanks in advance.