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?