回複:請問 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.