User Problem

I would like to be able to edit the join path and join type (left, inner, union, etc) of my query in visual mode because sometimes the query that gets generated after I select my columns is not joining the data between tables the way I want them to. 

Suggested Solutions

Add a way for users to select the join path between tables from visual mode.

Current Workarounds

You can switch to SQL mode to edit my query and write out the desired join path. An alternate method is to have multiple queries and then merge them within Visual SQL. In certain scenarios where the tables are joined by an intermediary table, you can purposely query a column from the intermediary table to the desired join path in visual mode. 

To change the join type across all visual mode charts, the join type between tables can be edited on the schema page. Foreign keys can also be added or removed from this page.