Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Put the structure of your data, a few sample rows, or both into a single text string. Craft a “prompt” to the AI with that information plus your natural language question.