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

In tests, all baselines achieved no more than 20% accuracy, while table-augmented generation did far better with 40% or better accuracy.