Is it possible to join tables using Query Rule?...

You can do that by either creating a CDT that represents a relationship or by mapping your CDT to a View (and creating the view in your RDBMs; the view would do the join).

More information to map to existing tables/views and to create relationships between CDTs at forum.appian.com/.../Defining_a_Custom_Data_Type

Thank you Eduardo!