1.
Select Help > Sample Data Library and open SAT.jmp and SATByYear.jmp.
2.
Display SATByYear.jmp.
3.
Select Tables > JMP Query Builder.
The current data table, SATByYear.jmp, is selected as the Primary table.
4.
Select SAT.jmp in the Available Tables list and click Secondary.
5.
Select SAT.jmp next to the Secondary button and view the Columns tab. The Join column shows that two columns have the same name and were joined.
Figure 5.33 Joined Columns
6.
Click Build Query.
1.
In the Available Columns list, select t1.State, t1.%Taking (2004), t2.2004 Verbal, and t2.2004 Math.
2.
Click Add.
3.
Select Distinct rows only to avoid saving duplicate rows.
4.
On the Query Preview tab, make sure that Update preview automatically is selected so that you can see the selected columns.
1.
In the Included Columns list, select t2.2004 Verbal and t2.2004 Math, and then click Add Selected Items to Filter .
Figure 5.34 Selected Filters
2.
Click the red triangle next to each filter and select Prompt on Run. Accept the default prompt message.
1.
Click Run Query.
2.
Click OK to create the data table.
Figure 5.35 Queried Data
See Build SQL Queries in Query Builder in Import Your Data for more information about features that also appear in Query Builder for databases.
Tips: 
If you try to query a Microsoft Excel file that has more than 255 columns, only 255 columns are imported. Instead, select File > Open to open the Excel file in the Excel Import Wizard, and save the file as a data table.

Help created on 7/12/2018