metropia
asked on
joining tables. one table has multiple records, one a single record
hello, I have two temporary tables that are created as part of a stored procedure.
both tables have the same structure:
[CustomerChainName]
, [SortGroup]
, [SortOrder]
, [Quantity_CurrentYear]
, [QuantityPriorYear]
, [VolumeChange]
, [GrowthPercent]
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.
both tables have the same structure:
[CustomerChainName]
, [SortGroup]
, [SortOrder]
, [Quantity_CurrentYear]
, [QuantityPriorYear]
, [VolumeChange]
, [GrowthPercent]
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER