https://youtube.com/shorts/Jcv_FmTshvM?si=LF6mAGbhC4NVocI-

Try CREATE TABLE AS SELECT command  
Its easy to use. See: CREATE TABLE AS SELECT (SQL) | InterSystems SQL Reference | InterSystems IRIS Data Platform 2025.2

Congratulations @John Murray 

I believe my first contact with you was back in 1998, during the MSM-Workstation era. That was when I began my journey into the MUMPS world, and you provided excellent support for the product. You probably don’t remember me, but I still recall how much I appreciated your quick and helpful email responses.