Doubts on how to do joins between tables in the metabase

[pedro_rebello]

I would like to know how it is possible to do joins in Metabase in the interface to builder?

[jornh]

For the Metabase core teams view on why they just didn't add joins front and center see these blog posts:

• https://www.metabase.com/blog/Joins/
• We put questions inside your questions

So, you can still do joins inside Metabase - it's just they sort-of hid it away for most users as "native SQL questions"... in particular I'd say the "Questions in Questions" approach combined with SQL knowledgeable users doing fancy stuff as pre-cooked qustions to build on for others is powerful.

The thread below may also shine some light on the topic - and how some of the (somewhat related) related PK-FK mapping shines trough in the UI

Create questions from multiple tables (SQL Join?)

Hi, Over the past few months I have created many SQL queries to retrieve the data from our MySQL database. Then I found Metabase which creates the charts for us and it’s very helpful to understand the data we need. The problem is that now with all the enhancements with the Metabase Questions I want to migrate my SQL to Metabase Questios, which I can’t. The biggest problem is that I can’t find how to JOIN fields from other tables or filter by them. Eg. I have an ID eg. 1888, for a user on tab…

I hope that answers some of what you were asking?