188161_es-ES

liliconcom

unión múltiple

Hola, estoy tratando de unir varias tablas y copié el script SQL del JMP Query Builder en un script, agregando algunos comandos al principio. Probablemente, ¿no funciona como es SQL y no como lenguaje JSL?

 

Mi problema es que en JMP Query Builder no tengo la opción de decidir qué columnas deben elegirse para la coincidencia de las filas. Cualquiera, ¿quién puede ayudarme aquí?

 

Este es el guión que ahora tengo. (La combinación de JSL y SQL)

dt=CurrentDataTable ();
dt<< SELECT * 
FROM "mon_trend Abs._OF 420nm 5cm"  t1 
 LEFT OUTER JOIN "mon_trend TOC mg l" t20 
  ON  (  ( t20.Site = t1.Site )  AND  ( t20.Season = t1.Season ) )
 LEFT OUTER JOIN "mon_trend Syrgashalt mg l" t19 
  ON  (  ( t19.Site = t1.Site )  AND  ( t19.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend Si mg l" t18 
  ON  (  ( t18.Site = t1.Site )  AND  ( t18.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend PO4-P µg l" t17 
  ON  (  ( t17.Site = t1.Site )  AND  ( t17.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend pH" t16 
  ON  (  ( t16.Site = t1.Site )  AND  ( t16.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend NO2-N µg l" t15 
  ON  (  ( t15.Site = t1.Site )  AND  ( t15.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend NO2+NO3-N µg l" t14 
  ON  (  ( t14.Site = t1.Site )  AND  ( t14.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend NH4-N µg l" t13 
  ON  (  ( t13.Site = t1.Site )  AND  ( t13.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend Na mekv l" t12 
  ON  (  ( t12.Site = t1.Site )  AND  ( t12.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend Mn µg l" t11 
  ON  (  ( t11.Site = t1.Site )  AND  ( t11.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend Mg mekv l" t10 
  ON  (  ( t10.Site = t1.Site )  AND  ( t10.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend Kond_25 mS m25" t9 
  ON  (  ( t9.Site = t1.Site )  AND  ( t9.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend K mekv l" t8 
  ON  (  ( t8.Site = t1.Site )  AND  ( t8.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend Fe µg l" t7 
  ON  (  ( t7.Site = t1.Site )  AND  ( t7.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend F mg l" t6 
  ON  (  ( t6.Site = t1.Site )  AND  ( t6.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend Cl mekv l" t5 
  ON  (  ( t5.Site = t1.Site )  AND  ( t5.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend Ca mekv l" t4 
  ON  (  ( t4.Site = t1.Site )  AND  ( t4.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend Alk. Acid mekv l" t3 
  ON  (  ( t3.Site = t1.Site )  AND  ( t3.Season = t1.Season ) )  
 LEFT OUTER JOIN "mon_trend Abs._F 420nm 5cm" t2 
  ON  (  ( t1.Site = t2.Site )  AND  ( t1.Season = t2.Season ) )  ;

Re: unión múltiple

Busque la función JMP Consulta()

 

Consulta (<< dt1 | Tabla (dt1, alias1)>, ..., >, , , sqlStatement)

Descripción

Realiza una consulta SQL en las tablas de datos seleccionadas.

 

Por supuesto, puede usar JMP Query Builder en un ascript. Cuando ejecutó el script JMP Query Builder y se ejecutó, la tabla resultante debería tener un script Run Query adjunto. Este es el script JSL para ejecutar la misma consulta.

 

Espero que ayude.

re