Issue with JMP Query Builder results
I am having an issue with the results from the JMP Query Builder. I generally use Microsoft Access to do queries, but my dataset is so big (13,148,520 rows) that my IT dept. suggested I try JMP Pro. I have two tables that I am linking on the "Covered_Recipient_Profile_ID" field:I am doing a left join on the "JMP table with AHC NPI 2AUG23" tableHere is my Query Preview:This query runs and returns S...