... > LEFT JOIN InvoiceI ON Video.Numero=InvoiceI.NoVideo > LEFT JOIN Invoice ON InvoiceI.NoInvoice=Invoice.Numero > AND Invoice.AddUser=1 > WHERE Program.Active > AND (InvoiceI.NoVideo IS NOT NULL > OR Video.Numero = ( > SELECT MIN(Video.Numero) FROM Program p2 > JOIN Video v2 ON P2.Numero=V2.NoProgram > WHERE p2.Numero = Program.Numero) > ) >This works as it gets the first video of the program but it still also retrieves the video purchased which is the second one. I am trying to adjust the SQL to only get the first video of the program no matter what video was purchased.