This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
With the regular Join tool, you would get 3 records coming out of the "J" connection and one from the "R" (assuming that database 2, with the D value is the right-hand table). To get your desired outcome, you could then put a Union tool in and 'add' the "R" output to the "J".
Alternatively, if you use the Join Multiple tool, you will get what you want right out of the box.
There are reasons to use Join vs. Join Multiple, so it is a good idea to look at the help docs and do some experimentation.