双11狂欢大促

盲盒赢 定制羽绒服

开启惊喜盲盒，抽取你的专属好礼

— 惊喜奖品抢先看 —

超级年卡50元券

周边70元券

手机支架

一拖三数据线

雨伞

运动毛巾

电动牙刷

VIP月卡

机械键盘

定制羽绒服

超级年卡50元券

周边70元券

手机支架

一拖三数据线

雨伞

运动毛巾

电动牙刷

VIP月卡

机械键盘

定制羽绒服

各位大神，请教一条SQL如何写？

2014-09-04 03:02:13 329 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

ap0606122 墨衍会员 · AI 创作全网分发关注 + 加入社区

【移动APP测试】Firebase Test Lab (FTL) 实战指南：从零搭建自动化测试流水线本文详细介绍了Firebase Test Lab (FTL) 在移动APP测试中的实战应用，从零搭建自动化测试流水线。通过真实设备、虚拟设备和iOS设备的全面覆盖，FTL帮助开发者高效进行兼容性测试、性能监控和崩溃分析，显著提升应用质量。文章还提供了设备选择策略、成本控制技巧和CI/CD集成的最佳实践，助力团队优化测试流程。阅读详情

A表：有1、2、3、4、5...10 这十种产品
B表：有A/B/C/D/E五个地区
C表：A表里面的十种产品分别在B表里面5个地区中的某几个销售过

现在需要查询一个结果，用一张表来表示A表里面的产品在B表中5个地区的销售情况
请教各位大神，这条SQL应该如何写？

...全文

机载电脑与飞控串口通信（实测读取飞控IMU数据）《一、香橙派5max启动串口UART通信与飞控板通信，一次必通！》《二、allspark1与PIX6C通信踩坑及出坑》《三、orinnx载板与飞控通信》机载电脑与飞控串口通信（实测读取飞控IMU数据）《一、香橙派5max启动串口UART通信与雷迅v5nano飞控板通信，一次必通！》《二、阿木机载电脑allspark1与PIX6C通信踩坑及出坑》，还有如何打开飞控串口以及如何提高飞控IMU频率。阅读详情

ap0606122

疑难问题 22,298 成员 121,727 内容

+ 关注 + 加入社区

切换为时间正序

kinbooLi 2014-09-06

打赏
举报

引用 16 楼 ap0606122 的回复:

[quote=引用 12 楼 ljb522744686 的回复:]

--A表：有1、2、3、4、5...10 这十种产品
--B表：有A/B/C/D/E五个地区
--C表：A表里面的十种产品分别在B表里面5个地区中的某几个销售过

--楼主C表应该是保存的是:A表里面的十种产品分别在B表里面5个地区中销售情况


--C表：      ID      AreaID         ProductID     ProductNum
--            1        2               5              3
--            1        3               4              2
--            1        5               5              4
--            1        7               2              5
--            1        3               5              1
--            1        4               5              6


--这样希望得到的结果应该是A表里面的产品在B表中5个地区的销售情况

--ProductName        Area1          Area2          Area3          Area4          Area5          
--	a                ?               ?             ?              ?              ?
--	b                ?               ?             ?              ?              ?
--	c                ?               ?             ?              ?              ?
--	d                ?               ?             ?              ?              ?
--	e                ?               ?             ?              ?              ?


WITH    tab_Product
          AS ( SELECT   '1' AS ProductID ,
                        'a' AS ProductName
               UNION ALL
               SELECT   '2' AS ProductID ,
                        'b' AS ProductName
               UNION ALL
               SELECT   '3' AS ProductID ,
                        'c' AS ProductName
               UNION ALL
               SELECT   '4' AS ProductID ,
                        'd' AS ProductName
               UNION ALL
               SELECT   '5' AS ProductID ,
                        'e' AS ProductName
             ),
        tab_Area
          AS ( SELECT   '1' AS AreaID ,
                        '上海' AS AreaName
               UNION ALL
               SELECT   '2' AS AreaID ,
                        '北京' AS AreaName
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '广州' AS AreaName
               UNION ALL
               SELECT   '4' AS AreaID ,
                        '深圳' AS AreaName
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '杭州' AS AreaName
             ),
        tab_Traffic
          AS ( SELECT   '2' AS AreaID ,
                        '5' AS ProductID ,
                        3 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '4' AS ProductID ,
                        2 AS ProductNum
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '5' AS ProductID ,
                        5 AS ProductNum
               UNION ALL
               SELECT   '1' AS AreaID ,
                        '2' AS ProductID ,
                        7 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '5' AS ProductID ,
                        10 AS ProductNum
               UNION ALL
               SELECT   '4' AS AreaID ,
                        '5' AS ProductID ,
                        5 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '2' AS ProductID ,
                        20 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '2' AS ProductID ,
                        13 AS ProductNum
               UNION ALL
               SELECT   '4' AS AreaID ,
                        '3' AS ProductID ,
                        4 AS ProductNum
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '1' AS ProductID ,
                        6 AS ProductNum
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '2' AS ProductID ,
                        3 AS ProductNum
             )
    --SELECT    a.ProductName ,
             --           b.AreaName ,
             --           c.ProductNum
             -- FROM      tab_Product a ,
             --           tab_Area b ,
             --           tab_Traffic c
             -- WHERE     c.AreaID = b.AreaID
             --           AND a.ProductID = c.ProductID
    SELECT  *
    FROM    ( SELECT    a.ProductName ,
                        b.AreaName ,
                        c.ProductNum
              FROM      tab_Product a ,
                        tab_Area b ,
                        tab_Traffic c
              WHERE     c.AreaID = b.AreaID
                        AND a.ProductID = c.ProductID
            ) t PIVOT ( SUM(t.ProductNum) FOR t.AreaName IN ( [上海], [北京], [广州],
                                                              [深圳], [杭州] ) ) AS piv

就是要的这种效果，你太厉害了，还有一个问题，因为tab_Area这张表里面的数据是动态的，IN ( [上海], [北京], [广州],[深圳], [杭州] )这里面写成动态，请问怎么写？ [/quote]

 DECLARE @s NVARCHAR(4000)
 SELECT @s = ISNULL(@s + ',', '') + QUOTENAME([AreaName])
 FROM   #tab_Area
 GROUP BY [AreaName]
 EXEC ( 'select ProductName,'+@s+' from (SELECT    a.ProductName ,
 b.AreaName ,
 CAST(c.ProductNum AS NUMERIC) ProductNum
 FROM      #tab_Product a ,
 #tab_Area b ,
 #tab_Traffic c
 WHERE     c.AreaID = b.AreaID
 AND a.ProductID = c.ProductID) t 
 pivot (SUM(t.ProductNum) FOR t.AreaName IN ('+@s+'))AS piv')

把原with 语句用临时表#tab_Product a ,#tab_Area b ,#tab_Traffic c 代替，其他信息不变。具体数据的行专列可参考http://bbs.csdn.net/topics/240002706

ap0606122 2014-09-05

打赏
举报

引用 12 楼 ljb522744686 的回复:

--A表：有1、2、3、4、5...10 这十种产品
--B表：有A/B/C/D/E五个地区
--C表：A表里面的十种产品分别在B表里面5个地区中的某几个销售过

--楼主C表应该是保存的是:A表里面的十种产品分别在B表里面5个地区中销售情况


--C表：      ID      AreaID         ProductID     ProductNum
--            1        2               5              3
--            1        3               4              2
--            1        5               5              4
--            1        7               2              5
--            1        3               5              1
--            1        4               5              6


--这样希望得到的结果应该是A表里面的产品在B表中5个地区的销售情况

--ProductName        Area1          Area2          Area3          Area4          Area5          
--	a                ?               ?             ?              ?              ?
--	b                ?               ?             ?              ?              ?
--	c                ?               ?             ?              ?              ?
--	d                ?               ?             ?              ?              ?
--	e                ?               ?             ?              ?              ?


WITH    tab_Product
          AS ( SELECT   '1' AS ProductID ,
                        'a' AS ProductName
               UNION ALL
               SELECT   '2' AS ProductID ,
                        'b' AS ProductName
               UNION ALL
               SELECT   '3' AS ProductID ,
                        'c' AS ProductName
               UNION ALL
               SELECT   '4' AS ProductID ,
                        'd' AS ProductName
               UNION ALL
               SELECT   '5' AS ProductID ,
                        'e' AS ProductName
             ),
        tab_Area
          AS ( SELECT   '1' AS AreaID ,
                        '上海' AS AreaName
               UNION ALL
               SELECT   '2' AS AreaID ,
                        '北京' AS AreaName
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '广州' AS AreaName
               UNION ALL
               SELECT   '4' AS AreaID ,
                        '深圳' AS AreaName
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '杭州' AS AreaName
             ),
        tab_Traffic
          AS ( SELECT   '2' AS AreaID ,
                        '5' AS ProductID ,
                        3 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '4' AS ProductID ,
                        2 AS ProductNum
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '5' AS ProductID ,
                        5 AS ProductNum
               UNION ALL
               SELECT   '1' AS AreaID ,
                        '2' AS ProductID ,
                        7 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '5' AS ProductID ,
                        10 AS ProductNum
               UNION ALL
               SELECT   '4' AS AreaID ,
                        '5' AS ProductID ,
                        5 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '2' AS ProductID ,
                        20 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '2' AS ProductID ,
                        13 AS ProductNum
               UNION ALL
               SELECT   '4' AS AreaID ,
                        '3' AS ProductID ,
                        4 AS ProductNum
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '1' AS ProductID ,
                        6 AS ProductNum
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '2' AS ProductID ,
                        3 AS ProductNum
             )
    --SELECT    a.ProductName ,
             --           b.AreaName ,
             --           c.ProductNum
             -- FROM      tab_Product a ,
             --           tab_Area b ,
             --           tab_Traffic c
             -- WHERE     c.AreaID = b.AreaID
             --           AND a.ProductID = c.ProductID
    SELECT  *
    FROM    ( SELECT    a.ProductName ,
                        b.AreaName ,
                        c.ProductNum
              FROM      tab_Product a ,
                        tab_Area b ,
                        tab_Traffic c
              WHERE     c.AreaID = b.AreaID
                        AND a.ProductID = c.ProductID
            ) t PIVOT ( SUM(t.ProductNum) FOR t.AreaName IN ( [上海], [北京], [广州],
                                                              [深圳], [杭州] ) ) AS piv

就是要的这种效果，你太厉害了，还有一个问题，因为tab_Area这张表里面的数据是动态的，IN ( [上海], [北京], [广州],[深圳], [杭州] )这里面写成动态，请问怎么写？

ap0606122 2014-09-05

打赏
举报

引用 13 楼 wtujedp 的回复:

同11楼一样，你要怎么样的结果格式。是下面这样的格式吗？长裤 A 10 长裤 B 20 长裤 C 30 短裙 A 10 短裙 B 20 短裙 C 30 短裙 E 555 风衣 A 130 风衣 B 320 风衣 C 320 风衣 D 40 风衣 E 555 连衣裙 C 30 连衣裙 D 40 连衣裙 E 33 上衣 A 10 上衣 B 20 上衣 D 40 上衣 E 555 围巾 A 10 围巾 B 20 围巾 C 30 围巾 D 40 围巾 E 555

是这种格式：产品名称广州上海香港大连重庆围巾 10 5 0 0 20 上衣 0 1 4 0 0 连衣裙 5 2 0 0 0 短裙 0 0 0 0 0 长裤 1 3 55 64 0 风衣 8 9 0 8 0

ap0606122 2014-09-05

打赏
举报

引用 9 楼 u010024618 的回复:

类似的例子：

IF OBJECT_ID('ta') IS NOT NULL
	DROP TABLE dbo.ta
GO

CREATE TABLE ta
(
  ProductID  INT NOT NULL PRIMARY KEY,
  ProductName NVARCHAR(32)
)
INSERT INTO dbo.ta 
SELECT 1,N'围巾'   UNION ALL
SELECT 2,N'上衣'   UNION ALL
SELECT 3,N'连衣裙' UNION ALL
SELECT 4,N'短裙'   UNION ALL
SELECT 5,N'长裤'   UNION ALL
SELECT 6,N'风衣' 
GO

IF OBJECT_ID('tb') IS NOT NULL
	DROP TABLE dbo.tb
GO

CREATE TABLE TB
(
	AreaID INT NOT NULL PRIMARY KEY,
	Area  NVARCHAR(32)
)
INSERT INTO TB	
SELECT 1,N'上海'   UNION ALL
SELECT 2,N'广州'   UNION ALL
SELECT 3,N'香港'   UNION ALL
SELECT 4,N'大连'   UNION ALL
SELECT 5,N'重庆'   
GO


IF OBJECT_ID('tc') IS NOT NULL
	DROP TABLE dbo.tc
GO

CREATE TABLE Tc
(
	ProductID  INT,
	AreaID    INT,
	Quantity   INT
)
ALTER TABLE tc ADD CONSTRAINT pk_ProductID FOREIGN KEY(ProductID) REFERENCES ta(ProductID)
ALTER TABLE tc ADD CONSTRAINT pk_AreaID    FOREIGN KEY(AreaID) REFERENCES tb(AreaID)

INSERT INTO tc	
SELECT  2 , 5 , 150 UNION ALL
SELECT  4 , 5 , 180 UNION ALL
SELECT  5 , 5 , 50 UNION ALL
SELECT  6 , 2 , 210 UNION ALL
SELECT  3 , 5 , 330 UNION ALL
SELECT  4 , 5 , 70
GO

SELECT * FROM dbo.ta
SELECT * FROM TB
SELECT * FROM tc

WITH t AS (
SELECT ProductID,AreaID,SUM(Quantity) 'Quantity' FROM tc 
GROUP BY ProductID,AreaID
) 
SELECT ta.ProductName N'产品名称',TB.Area N'销售地区',t.Quantity '销售总量'
				 FROM t INNER JOIN ta  ON t.ProductID = ta.ProductID
				 INNER JOIN TB  ON t.AreaID = TB.AreaID

产品名称销售地区销售总量 -------------------------------- -------------------------------- ----------- 风衣广州 210 上衣重庆 150 连衣裙重庆 330 短裙重庆 250 长裤重庆 50

就是要的这个效果，多谢了

wtujedp 2014-09-05

打赏
举报

同11楼一样，你要怎么样的结果格式。是下面这样的格式吗？长裤 A 10 长裤 B 20 长裤 C 30 短裙 A 10 短裙 B 20 短裙 C 30 短裙 E 555 风衣 A 130 风衣 B 320 风衣 C 320 风衣 D 40 风衣 E 555 连衣裙 C 30 连衣裙 D 40 连衣裙 E 33 上衣 A 10 上衣 B 20 上衣 D 40 上衣 E 555 围巾 A 10 围巾 B 20 围巾 C 30 围巾 D 40 围巾 E 555

kinbooLi 2014-09-04

打赏
举报

--A表：有1、2、3、4、5...10 这十种产品
--B表：有A/B/C/D/E五个地区
--C表：A表里面的十种产品分别在B表里面5个地区中的某几个销售过

--楼主C表应该是保存的是:A表里面的十种产品分别在B表里面5个地区中销售情况


--C表：      ID      AreaID         ProductID     ProductNum
--            1        2               5              3
--            1        3               4              2
--            1        5               5              4
--            1        7               2              5
--            1        3               5              1
--            1        4               5              6


--这样希望得到的结果应该是A表里面的产品在B表中5个地区的销售情况

--ProductName        Area1          Area2          Area3          Area4          Area5          
--	a                ?               ?             ?              ?              ?
--	b                ?               ?             ?              ?              ?
--	c                ?               ?             ?              ?              ?
--	d                ?               ?             ?              ?              ?
--	e                ?               ?             ?              ?              ?


WITH    tab_Product
          AS ( SELECT   '1' AS ProductID ,
                        'a' AS ProductName
               UNION ALL
               SELECT   '2' AS ProductID ,
                        'b' AS ProductName
               UNION ALL
               SELECT   '3' AS ProductID ,
                        'c' AS ProductName
               UNION ALL
               SELECT   '4' AS ProductID ,
                        'd' AS ProductName
               UNION ALL
               SELECT   '5' AS ProductID ,
                        'e' AS ProductName
             ),
        tab_Area
          AS ( SELECT   '1' AS AreaID ,
                        '上海' AS AreaName
               UNION ALL
               SELECT   '2' AS AreaID ,
                        '北京' AS AreaName
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '广州' AS AreaName
               UNION ALL
               SELECT   '4' AS AreaID ,
                        '深圳' AS AreaName
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '杭州' AS AreaName
             ),
        tab_Traffic
          AS ( SELECT   '2' AS AreaID ,
                        '5' AS ProductID ,
                        3 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '4' AS ProductID ,
                        2 AS ProductNum
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '5' AS ProductID ,
                        5 AS ProductNum
               UNION ALL
               SELECT   '1' AS AreaID ,
                        '2' AS ProductID ,
                        7 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '5' AS ProductID ,
                        10 AS ProductNum
               UNION ALL
               SELECT   '4' AS AreaID ,
                        '5' AS ProductID ,
                        5 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '2' AS ProductID ,
                        20 AS ProductNum
               UNION ALL
               SELECT   '3' AS AreaID ,
                        '2' AS ProductID ,
                        13 AS ProductNum
               UNION ALL
               SELECT   '4' AS AreaID ,
                        '3' AS ProductID ,
                        4 AS ProductNum
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '1' AS ProductID ,
                        6 AS ProductNum
               UNION ALL
               SELECT   '5' AS AreaID ,
                        '2' AS ProductID ,
                        3 AS ProductNum
             )
    --SELECT    a.ProductName ,
             --           b.AreaName ,
             --           c.ProductNum
             -- FROM      tab_Product a ,
             --           tab_Area b ,
             --           tab_Traffic c
             -- WHERE     c.AreaID = b.AreaID
             --           AND a.ProductID = c.ProductID
    SELECT  *
    FROM    ( SELECT    a.ProductName ,
                        b.AreaName ,
                        c.ProductNum
              FROM      tab_Product a ,
                        tab_Area b ,
                        tab_Traffic c
              WHERE     c.AreaID = b.AreaID
                        AND a.ProductID = c.ProductID
            ) t PIVOT ( SUM(t.ProductNum) FOR t.AreaName IN ( [上海], [北京], [广州],
                                                              [深圳], [杭州] ) ) AS piv

唐诗三百首 2014-09-04

打赏
举报

现在需要查询一个结果，用一张表来表示A表里面的产品在B表中5个地区的销售情况 --> "产品在地区的销售情况"不明确, 请提供希望结果的具体格式.

hleb231 2014-09-04

打赏
举报

是要这样吧


select  productname as 产品,area 地区 ,count(1)销售次数 
from 
 (select #A.ProductName,#B.area 
from #C left join  #A  on #C.productid =#A.id
left join  #B  on #c.areaid=#B.areaid  ) a 
group by productname,area

产品         地区         销售次数
---------- ---------- -----------
 长裤         大连        1
 长裤         广州        1
上衣          广州        1
 长裤         香港        1
 短裙         香港        1
 长裤        重庆         1

freecodex 2014-09-04

打赏
举报

类似的例子：

IF OBJECT_ID('ta') IS NOT NULL
	DROP TABLE dbo.ta
GO

CREATE TABLE ta
(
  ProductID  INT NOT NULL PRIMARY KEY,
  ProductName NVARCHAR(32)
)
INSERT INTO dbo.ta 
SELECT 1,N'围巾'   UNION ALL
SELECT 2,N'上衣'   UNION ALL
SELECT 3,N'连衣裙' UNION ALL
SELECT 4,N'短裙'   UNION ALL
SELECT 5,N'长裤'   UNION ALL
SELECT 6,N'风衣' 
GO

IF OBJECT_ID('tb') IS NOT NULL
	DROP TABLE dbo.tb
GO

CREATE TABLE TB
(
	AreaID INT NOT NULL PRIMARY KEY,
	Area  NVARCHAR(32)
)
INSERT INTO TB	
SELECT 1,N'上海'   UNION ALL
SELECT 2,N'广州'   UNION ALL
SELECT 3,N'香港'   UNION ALL
SELECT 4,N'大连'   UNION ALL
SELECT 5,N'重庆'   
GO


IF OBJECT_ID('tc') IS NOT NULL
	DROP TABLE dbo.tc
GO

CREATE TABLE Tc
(
	ProductID  INT,
	AreaID    INT,
	Quantity   INT
)
ALTER TABLE tc ADD CONSTRAINT pk_ProductID FOREIGN KEY(ProductID) REFERENCES ta(ProductID)
ALTER TABLE tc ADD CONSTRAINT pk_AreaID    FOREIGN KEY(AreaID) REFERENCES tb(AreaID)

INSERT INTO tc	
SELECT  2 , 5 , 150 UNION ALL
SELECT  4 , 5 , 180 UNION ALL
SELECT  5 , 5 , 50 UNION ALL
SELECT  6 , 2 , 210 UNION ALL
SELECT  3 , 5 , 330 UNION ALL
SELECT  4 , 5 , 70
GO

SELECT * FROM dbo.ta
SELECT * FROM TB
SELECT * FROM tc

WITH t AS (
SELECT ProductID,AreaID,SUM(Quantity) 'Quantity' FROM tc 
GROUP BY ProductID,AreaID
) 
SELECT ta.ProductName N'产品名称',TB.Area N'销售地区',t.Quantity '销售总量'
				 FROM t INNER JOIN ta  ON t.ProductID = ta.ProductID
				 INNER JOIN TB  ON t.AreaID = TB.AreaID

产品名称销售地区销售总量 -------------------------------- -------------------------------- ----------- 风衣广州 210 上衣重庆 150 连衣裙重庆 330 短裙重庆 250 长裤重庆 50

ap0606122 2014-09-04

打赏
举报

引用 6 楼 u010024618 的回复:

[quote=引用 4 楼 ap0606122 的回复:] [quote=引用 3 楼 wtujedp 的回复:] 表结构是怎么的，测试数据放一点

A表： ID ProductName 1 围巾 2 上衣 3 连衣裙 4 短裙 5 长裤 6 风衣 .... B表： AreaID Area 1 上海 2 广州 3 香港 4 大连 5 重庆 C表：ID AreaID ProductID 1 2 5 1 3 4 1 5 5 1 7 2 1 3 5 1 4 5 .....[/quote] 请问，您C表中的ProductID引用的是A表中的ID，那么C表中的ID有什么意义[/quote] ID没有特殊意义就是一个自增字段

挑食的小孩 2014-09-04

打赏
举报

select 产品名，count(产品编号) as 销售量 from C表 inner join A表。。。 group by 地区，大概的思路是这样，你看下可以吗

freecodex 2014-09-04

打赏
举报

引用 4 楼 ap0606122 的回复:

[quote=引用 3 楼 wtujedp 的回复:] 表结构是怎么的，测试数据放一点

qq_15654157 2014-09-04

打赏
举报

引用 4 楼 ap0606122 的回复:

[quote=引用 3 楼 wtujedp 的回复:] 表结构是怎么的，测试数据放一点

A表： ID ProductName 1 围巾 2 上衣 3 连衣裙 4 短裙 5 长裤 6 风衣 .... B表： AreaID Area 1 上海 2 广州 3 香港 4 大连 5 重庆 C表：ID AreaID ProductID 1 2 5 1 3 4 1 5 5 1 7 2 1 3 5 1 4 5 .....[/quote] C表的ID怎么可以都是1呢？

ap0606122 2014-09-04

打赏
举报

引用 3 楼 wtujedp 的回复:

表结构是怎么的，测试数据放一点

A表： ID ProductName 1 围巾 2 上衣 3 连衣裙 4 短裙 5 长裤 6 风衣 .... B表： AreaID Area 1 上海 2 广州 3 香港 4 大连 5 重庆 C表：ID AreaID ProductID 1 2 5 1 3 4 1 5 5 1 7 2 1 3 5 1 4 5 .....

wtujedp 2014-09-04

打赏
举报

表结构是怎么的，测试数据放一点

ap0606122 2014-09-04

打赏
举报

各位大神不能给点意见么？在线求答案

ap0606122 2014-09-04

打赏
举报

我试了行转列，但是不知道如何对应上去

✦双11狂欢大促✦

各位大神，请教一条SQL如何写？

相关推荐

双11狂欢大促