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.
(2) Right Join
This returns all the records from the right table and just the matched records from the left table.
(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.
Having 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.