Display Relational Data from 2 tables

I normally use SQL. I am having to adapt my SQL code to fit this plugin. Is there a feature to enter my SQL code and generate the report (publication)?
I have 2 tables, 1 to many relationship, using JOINS.
– They are connected by USER_ID field.
– I have created 1 Project with 1 Page that is a Parent/Child type with a WHERE clause ‘membership_id = 1 and Date(enddate) >= CURDATE()’
– Both tables are listed in Manage Table Options. With the appropriate linked table and column name.
– I can see the relational data after viewing the project name. So I know the relation is working. The WHERE clause is also working.
I am having problem displaying the data. I have added a publication. However, I can only choose one existing WP table, NOT the relational table I created in Project. The columns that are listed are the ones in the one existing table.
I can display the data on the WP website, but it is only my selected columns from the Publication settings.
I need to know how display my relational table created in Data Project?

The page I need help with: [log in to see the link]