Editing the SQL query for a relational view
You can edit the SQL query for your relational view by using the View Query page in the View Builder.
The View Query page is the same as the SQL Query Builder. As you modify the query for the view, you can go back to the View Details page to see the columns for your relational view.
Parent topic
Accessing and updating data