[[poliburro]]

Dependiendo de lo que deses obtener, sería Left right, Inner, Full

Código SQL [-]

     Select Ped.no, Ped.no_ped, Ped.dpto, Ped.status,
            Ped.user, Ped.date
       From Reg_Pedidos As Ped
  Left Join Historico As Hist
         On Ped.No = Hist.No