• In this case I would consider using a temporary table

    😎