It is technically only possible to directly connect a cardPresso project to a single table/view.
Having no way to merge the multiple target tables in a single view, the only solution will be using some cardPresso scripting.
Note however that it will only be possible to do that using databases that support SQL queries (such as MS Access, SQL Server, Oracle, etc.), but the returned information cannot be displayed in the same location as the directly connected table data.
You can refer to the following document, which explains how setup the described environment.