This issue is solved, I just had to save the query with the changes I made before attempting to export.

Apparently you can run a query after fixing errors without saving...

Thanks for the reply but there are actually 8 lines in that second select statement.

The problem was occurring because I originally did have mismatched numbers of columns. I fixed this...