回复：请问 SQL 高手

来源: 于 2009-06-16 17:50:51 [旧帖] [给我悄悄话] 本文已被阅读：次

Method 1. Use pivot table
Method 2. Left join to many sub-queries; each sub-query is for one storeId group by ItemId.