>This query will work because it is not doing any join to the invoice tables, it is only joining the program master to the videos in the program and getting the first video that is part of the program. Unless I misunderstand what the Program and Video tables are storing.

After more adjustments, I succeeded in making this work with this approach. However, I cannot include my memo fields in the query because those cannot be encapsulated with the MIN() syntax:

SELECT Program.Numero,MIN(Program.Title) AS Title,MIN(Video.Numero);
 FROM Program;
 INNER JOIN Video ON Program.Numero=Video.NoProgram;
 INNER JOIN Master ON Program.NoMaster=Master.Numero;
 INNER JOIN MasterType ON Master.NoMasterT=MasterType.Numero;
 WHERE Program.Active AND Program.Numero IN;
  (SELECT Program2.Numero FROM Program Program2;
  INNER JOIN Video Video2 ON Program2.Numero=Video2.NoProgram;
  INNER JOIN InvoiceI ON Video2.Numero=InvoiceI.NoVideo;
  INNER JOIN Invoice ON InvoiceI.NoInvoice=Invoice.Numero AND Invoice.AddUser=1);
 ORDER BY 2;
 GROUP BY Program.Numero

What can I do in order to include my memo fields in this query?