New SQL Query -- Join when one dt has variable # of columns
I have a script that joins four tables using the JMP Query Builder. A condensed example of the script is below. This works with a fixed number of columns, however dt1 can have any number of columns and I need to incorporate all of them. The remaining three tables have specific columns for inclusion, all other columns need to be dropped. Names Default to Here( 1 );
dt1 = Open( "C:\...\dt1.jmp", in...