1.
Select File > New > Database Query, connect to the database, and select the SQBTest schema. (See Connect to a Database for details.)
2.
In the Select Tables for Query window, select g6_Rentals as the Primary table.
3.
Select g6_Movies and g6_Customers as the Secondary tables.
4.
Click Build Query to show the Query Builder window.
5.
Click the Add All button on the Included Columns tab.
6.
From the Query Builder red triangle menu, select Convert to Custom SQL and click OK.
WHERE (  (  ( t2.Gender IN  ( 'F' )  )  AND  (  (t2.Age >= 20)  AND  (t2.Age <= 50)  )  )  )
8.
Click Run Query to import the data into JMP.
Note: If you select Revert to Interactive from the red triangle menu, the changes that you made on the Custom SQL tab are not saved. If you save the custom query and reopen it, Revert to Interactive is not available.
See Structured Query Language (SQL): A Reference for a brief primer of SQL statements.

Help created on 7/12/2018