Re: Consulta complicada

[William Chiquito]

Hola Sand,

Trata con:

SELECT p.tarjeta, p.apellido, c.fecha, MIN(c.hora), MAX(c.hora)
FROM personal p
	INNER JOIN cronos c ON p.Tarjeta = c.Tarjeta
GROUP BY p.tarjeta, c.fecha;

Edited 1 time(s). Last edit at 12/03/2007 08:41PM by William Chiquito.