Export WordPress Posts and Meta Data in CSV format

I have to export all WordPress Posts and associated Meta info utilizing an SQL question. I’ve managed to export simply the Posts however realised that the Meta info is in one other desk.

Might somebody please inform me how I’d go about doing this please?

Thanks!

EDIT: The ultimate consequence of the CSV file ought to look one thing like this.

[POSTS TABLE] post_content | post_title | post_excerpt | Creator (meta_key) | [META TABLE] AuthorName (meta_value) | Writer (meta_key) | PublisherName (meta_value) | BookCondition (meta_key) | BookCondition (meta_value)

So one submit per row with the meta info in a single row however in the identical column.