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!

[Weedpacket]

On most DBMSs you can create the new table and then write "Create table table name as Select whatever"

You'll need to consult your database program's documentation to verify this for your situation.

[Betty_S]

thaks