No idea, yet.
I'm able to join 5 different tables by dragging and dropping from one column to another in the query builder.
Are you getting the error message when you try to drag and drop the table into the query builder or when you try to drag the columns together to define the join?
I get the error as soon as I switch over from the SQL worksheet. For example, here are the steps I follow:
1) Run query 1 from worksheet:
Results show up in the results pane below
2) Add query 2 to worksheet:
Results show up in results pane as expected.
3) Click 'Query Builder' to build relationships
4) Receive Error Message as described earlier
Is it because I am running two queries on the worksheet?
My main objective is to be able to add tables and build relationships/queries via the Query Builder. Let me know if you think there is a different way to do this other than starting in the worksheet.
Thanks for the quick reply!
yes, you can only have one query per worksheet to use the query builder
Ok - thanks. So how did you add five tables to the query builder? Can you please refer me to some resources that will help me use the builder? I tried the 'Help' files but it didn't show me how to add tables...at least that I could follow.
Thanks for your help.
Just drag and drop them into the query builder space...or add them to your FROM clause in the worksheet and toggle back to the query builder