1.
Select Help > Sample Data Library and open Trial1.jmp and Little.jmp.
2.
Click on Trial1.jmp to make it the active data table.
3.
Select Tables > Join.
4.
In the Join ‘Trial1’ With box, select Little.
5.
From the Matching Specification menu, select By Matching Columns.
6.
In the Source Columns boxes, select popcorn in both boxes, and then click Match.
7.
In the same way, match batch and oil amt to oil in both boxes.
8.
Select Include non-matches for both tables.
9.
To avoid duplicate columns, select the Select columns for joined table option.
10.
From Trial1, select all four columns and click Select.
11.
From Little, select only yield and click Select.
Completed Join Window
12.
Joined Table

Help created on 9/19/2017