In regards to your question about doing a combined query, there is a module that might help you. It's called Genezzo. You can directly create or manipulate database tables with it. It's simple and can be done from the command-line.

See:

Genezzo