Method 2. Left join to many sub-queries; each sub-query is for one storeId group by ItemId.
回複:請問 SQL 高手
Method 1. Use pivot table
Method 2. Left join to many sub-queries; each sub-query is for one storeId group by ItemId.
Method 2. Left join to many sub-queries; each sub-query is for one storeId group by ItemId.
所有跟帖:
• 回複:回複:請問 SQL 高手 -布衣之才- ♂ (152 bytes) () 06/16/2009 postreply 18:10:20