hello, I have two temporary tables that are created as part of a stored procedure.
both tables have the same structure:
The first table contains the top 30 customers with highest growth percentage, and the other table contains a single row that shows totals for all the other customers (not top 30)
my question is, what type of join would I have to use in this case?
any example would be great.
Thank you very much.