Hola
Código Delphi
[-]
ZQuery2.Close;
ZQuery2.SQL.Clear;
ZQuery2.SQL.Add('Select antes from DetallePersonal Inner Join TipoPersonal on cedula = :Num0 and cod_tipo = :Num1 and antes <> :Num2 ');
ZQuery2.Params[0].Value:= quotedstr(cedula);
ZQuery2.Params[1].Value:= codigo; ZQuery2.Params[2].Value:= "00:00:00";
ZQuery2.Open;
IF Not ZQuery2.Eof Then
cadenaantes:= ZQuery2.FieldbyName('Antes').AsString
Else
cadenaantes:='00:00';
Saludos
PD: Tienes dos tablas, que campo es de que tabla???????