pysqlplus_union_short.py

def union(self, table_list, name="union", join="UNION"):
    
    # initialise the query
    query = "SELECT * INTO ["+name+"] FROM (\n"

    # build the SQL query
    query += f'\n{join}\n'.join(
                        [f'SELECT [{x}].* FROM [{x}]' for x in table_list]
                        )

    query += ") x"  # add end of query
    self.manual(query, fast=True)  # fast execute