User Community
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: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

JMP Knowledge Base

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

Recommended Articles