Código SQL [-]Select E.E, E.Ficha as Ficha_E, E.Fecha as Fecha_E, E.Hora as Hora_E (Select S.S, S.Ficha as Ficha_S, S.Fecha as Fecha_S, S.Hora as Hora_S from Tu_Tabla S where S.S = 0 and S.Fecha = E.Fecha) from Tu_Tabla E where E.E = 1
Select E.E, E.Ficha as Ficha_E, E.Fecha as Fecha_E, E.Hora as Hora_E (Select S.S, S.Ficha as Ficha_S, S.Fecha as Fecha_S, S.Hora as Hora_S from Tu_Tabla S where S.S = 0 and S.Fecha = E.Fecha) from Tu_Tabla E where E.E = 1