>SELECT Program.Numero,Program.Active,Program.Title,Program.Notes_E,Program.Notes_F,Program.NoMaster,; > Master.FirstName,Master.LastName,MasterType.Title_E AS MasterType_E,MasterType.Title_F AS MasterType_F,Video.Url,Video.Numero AS PrimaryKey; > FROM Program; > INNER JOIN Master ON Program.NoMaster=Master.Numero; > INNER JOIN MasterType ON Master.NoMasterT=MasterType.Numero; > INNER JOIN Video ON Program.Numero=Video.NoProgram; > INNER JOIN InvoiceI ON Video.Numero=InvoiceI.NoVideo; > INNER JOIN Invoice ON InvoiceI.NoInvoice=Invoice.Numero; > WHERE Program.Active AND Invoice.AddUser=1; > AND Video.Numero=(SELECT MIN(Numero) FROM Video V WHERE V.NoProgram=Video.NoProgram); > ORDER BY Program.Title >Thanks, but there must be a syntax that is not shown because if I try my original SQL, it does return one record but it is not the first one from the program. When I try yours, it doesn't return any record.