In this post, the left table (or table A), means the table you're starting from. The right table (or table B), means the table you're bringing in.

1️⃣ Left Join (the default in Trevor)

This returns all the records from the left table and the matching records from the right table. 

Note: this means that anything that doesn't find a matching row in table A won't be displayed.

2️⃣ Right Join

This returns all the records from the right table and just the matched records from the left table. 

Note: this means that anything that doesn't find a matching row in table B won't be displayed.

3️⃣ Inner Join

This returns all the records with matching values from both tables.

4️⃣ Outer Join

This returns matched and unmatched records from both tables.

In Trevor, you can access these options clicking the advanced link within the Join modal. 

---------

Have a question?

We're on standby to help! To chat with us, click the blue Intercom button in the bottom right of Trevor's interface.