How to export multiple tables as one csv file

How would a client of mine export a mysql database in say a .csv format, when the data is abstracted across multiple tables? (Since having a crack at normalising my database, it has become less human-readable!)

Is there way in phpmyadmin to perform an SQL command that say joins all tables together and then export the results of the SQL? That could potentially be a large amount of data though…

Any ideas so the client can have a readable spreadsheet file ie. .csv?

most front end apps (e.g. phpmyadmin) can export the result of a query

Check below tutorial. It will guide you through the exact steps: