cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Supported Join types for Table > JMP Query Builder
Created: Nov 30, 2022 02:30 PM  |  Last Modified: Dec 23, 2022 8:45 AM

JMP® Query Builder can be used to join two JMP tables. However, some may notice the option to "Include non-matching rows from table" is grayed out. 

 

JoinImage.JPG

 

 

 

 

 

 

 

 

 

JMP uses SQLite as its database engine for Table > JMP Query Builder. SQLite supports only the following Join types:

  • Inner-Join: returns rows when there is a match in both tables
  • Left-Join: returns all rows from the left table, even if there are no matches in the right table

Note: For those who desire to create right-joins, you can switch the order of the tables, when selecting Primary and Secondary tables, within the Table > JMP Query Builder user interface. Also, this note is applicable only to Table > JMP Query Builder. It is not applicable to File > Database > Query Builder, unless you are accessing an SQLite database within File > Database > Query Builder.

 

[Previously JMP Note 59817]

0 Kudos
Details
Operating System
macOS Windows
Products JMP Pro JMP