How can create a new permanent table and fill it up with rows form existing tables

[Betty_S]

Hi,

I did a ’join’ between 5 tables and I would like to save the output into a new permanent table.

Thanks!

[leatherback]

Hi,

I think you can use:
'Select ... INTO ...'

Check mysql.org => manual for your version of mysql;