have you tried creating a UNION ?
plase read this article:
Union tables manually
Use this method to manually union distinct tables. This method allows you to drag individual tables from the left pane of the Data Source page and into the Union dialog box.
To union tables manually
- On the data source page, double-click New Union to set up the union.
- Drag a table from the left pane to the Union dialog box.
- Select another table from the left pane and drag it directly below the first table.Tip: To add multiple tables to a union at the same time, press Shift or Ctrl (Shift or Command on a Mac), select the tables you want to union in the left pane, and then drag them directly below the first table.
- Click Apply or OK to union.