Here's some additional information to help with my needs:
The final outcome of the CSV file should look something like this. On one row, these are the columns that I will end up with. (I will delete the additional columns in CSV, I'm just giving a shortened version here)
[FROM POSTS TABLE] post_content | post_title | post_excerpt | Author (meta_key) | [FROM META TABLE] AuthorName (meta_value) | Publisher (meta_key) | PublisherName (meta_value) | BookCondition (meta_key) | BookCondition (meta_value)
So one post per row with the meta information in the same row.
I have already tried a number of plugins, none of which have worked for this specific scenario. I really do need to work on the query itself. Thanks