SELECT Program.Numero,MIN(Video.Numero) AS FirstVideo ; FROM Program; INNER JOIN Video ON Program.Numero=Video.NoProgram; WHERE Program.Numero = TheProgramYouWant ; GROUP BY Program.Numero