>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 >This would not work because not all videos of a program could be part of the result. Thus, if the user only purchased the 2nd and 3rd video of the program, I will not be able to extract the first one of the program by the use of MIN() as it will not be part of the INNER JOIN.