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

I have sort of an odd situation. I have a lot of distributed machines working on a simulation. They each start out with their own work, process it, and eventually put it into a SQL database ...