Search code examples
sqlexcelms-query

MSQuery how to inner join 2 tables with allias (excel odbc)

I've been trying to get the last row of each ean (id) because it has several TimeStamps (tmh), but I can't get it on MSQuery with ODBC conexions...Some suggests?

SELECT TMH, PESO, ALTO, ANCHO, LARGO, EAN FROM 

(SELECT TMH219 as TMH, PES219 AS PESO, ALT219 AS ALTO, ANC219 AS ANCHO, LAR219 AS LARGO, EAN219 AS EAN FROM SGAVDL.SGA21900) T1

INNER JOIN (SELECT EAN219, MAX(TMH219) FROM SGAVDL.SGA21900) T2

ON T1.EAN219 = T2.EAN219

GROUP BY  TMH, PESO, ALTO, ANCHO, LARGO, EAN

Thank you in advance!

Solution

  • With below query you should get 

    SELECT T1.TMH219 as TMH, PES219 AS PESO, ALT219 AS ALTO, ANC219 AS ANCHO, LAR219 AS LARGO, T1.EAN219 AS EAN FROM 
SGAVDL.SGA21900 T1 INNER JOIN (SELECT MAX(TMH219) TMH219 FROM SGAVDL.SGA21900) T2
ON T1.TMH219=T2.TMH219