Read this SQL tutorial to learn when to use SELECT ... You can call more than one table in the statement’s FROM clause to combine results from multiple tables. Here’s an example of how ...

How could I construct a view which would pull data from each of 5 tables so that a report could be built against the one view?

Data stored in MySQL databases is accessed using query commands similar to those in standard Structured Query Language, or SQL ... tables in the different tables that you want to merge. Combine ...