... 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) )>From the following SQL, I obtain some video information in regards to the video purchased by a user, when the video is part of a program. A program contains multiple videos.
>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; > ORDER BY Program.Title >>