>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.
This is what I thought on second thaught. Then, I tried to make that GROUP BY clause and was not able to. I understand I would have to put MIN() everywhere on the field definition. But, even if I have only two fields in the field definition, as soon as I insert the GROUP BY clause, I have a GROUP BY clause is missing or invalid.