昨天的那个数据搞错了,重新再开一个..

2009-10-13 11:01:56 294 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

保姆级教程：用HFSS 2023 R2搞定GPS右旋圆极化微带天线（从建模到优化全流程）本文提供了一份详细的HFSS 2023 R2教程，指导读者从零开始设计GPS右旋圆极化微带天线。涵盖建模、仿真和优化全流程，特别关注圆极化特性的实现与优化，帮助工程师快速掌握天线设计的关键技术。阅读详情

MaterialAtInfo:
OrderNo Name Color AtAmount Place
------- ---- ------ ----------- -----
A01 AA Red 60 A1
A01 AA Yellow 500 A2
A02 BB Bule 0 A3
A03 CC Black 300 A4
A04 DD White 400 A5

MaterialInInfo:
OrderNo Name Color InAmount Place
------- ---- ------ ----------- -----
A01 AA Red 50 A1
A01 AA Red 50 A1
A01 AA Yellow 500 A2
A02 BB Bule 100 A3
A03 CC Black 300 A4
A04 DD White 400 A5

MaterialOutInfo:
OrderNo Name Color OutAmount Place
------- ---- ------ ----------- -----
A01 AA Red 20 A1
A01 AA Red 20 A1
A02 BB Bule 100 A3

结果:
OrderNo Name Color InAmount AtAmount OutAmount Place
------- ---- ------ ----------- ----------- ----------- -----
A01 AA Red 100 60 40 A1
A01 AA Yellow 500 500 0 A2
A02 BB Bule 100 0 100 A3
A03 CC Black 300 300 0 A4
A04 DD White 400 400 0 A5

...全文

怎么用phpstudy制作网站随着实践的深入，你会逐渐掌握更多高级技巧和技术，让你的网站变得更加完善和吸引人。现在你已经成功设置了你的本地Web服务器环境，接下来我们将指导你如何利用这个环境来创建一个简单的PHP网页项目。为了使网站更加动态且功能丰富，我们需要学会如何让PHP脚本与MySQL数据库交互。为了让网站看起来更专业美观，可以考虑引入CSS样式表来定制网页布局及视觉效果。当你对本地开发的网站感到满意后，下一步就是将其发布到互联网上供他人访问了。让我们进一步扩展我们的网站，加入一个简单的用户注册与登录系统。阅读详情

cookies10wen

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

+ 关注 + 加入社区

切换为时间正序

dealer_man 2009-10-14

打赏
举报

顶一个。

SQL77 2009-10-13

打赏
举报

[Quote=引用 8 楼 dawugui 的回复:]
SQL codecreatetable tb1(OrderNovarchar(10),Namevarchar(10),Colorvarchar(10), AtAmountint, Placevarchar(10))insertinto tb1values('A01','AA','Red' ,60 ,'A1')insertinto tb1values('A01','AA','Yellow¡
[/Quote]
顶乌龟大侠

gsk09 2009-10-13

打赏
举报

这样的数据要什么结果
MaterialAtInfo:
OrderNo Name Color AtAmount Place
------- ---- ------ ----------- -----
A01 AA Red 60 A1
A01 AA Yellow 500 A2
A02 BB Bule 0 A3
A03 CC Black 300 A4
A04 DD White 400 A5

MaterialInInfo:
OrderNo Name Color InAmount Place
------- ---- ------ ----------- -----
A01 AA Red 50 A1
A01 AA Red 50 A1
A01 AA Yellow 500 A2
A02 BB Bule 100 A3
A03 CC Black 300 A4

MaterialOutInfo:
OrderNo Name Color OutAmount Place
------- ---- ------ ----------- -----
A01 AA Red 20 A1
A01 AA Red 20 A1
A02 BB Bule 100 A3
A04 DD White 400 A5

dawugui 2009-10-13

打赏
举报

我好象记得昨天就给你写了.

dawugui 2009-10-13

打赏
举报

create table tb1(OrderNo varchar(10),Name varchar(10),Color varchar(10), AtAmount  int,  Place varchar(10))

insert into tb1 values('A01',    'AA',  'Red'   , 60    ,     'A1') 

insert into tb1 values('A01',    'AA',  'Yellow', 500   ,     'A2') 

insert into tb1 values('A02',    'BB',  'Bule'  , 0     ,     'A3') 

insert into tb1 values('A03',    'CC',  'Black' , 300   ,     'A4') 

insert into tb1 values('A04',    'DD',  'White' , 400   ,     'A5') 



create table tb2(OrderNo varchar(10),Name varchar(10),Color  varchar(10),InAmount  int,  Place varchar(10))

insert into tb2 values('A01'  ,  'AA' , 'Red   ' ,50  ,       'A1 ')

insert into tb2 values('A01'  ,  'AA' , 'Red   ' ,50  ,       'A1 ')

insert into tb2 values('A01'  ,  'AA' , 'Yellow' ,500 ,       'A2 ')

insert into tb2 values('A02'  ,  'BB' , 'Bule  ' ,100 ,       'A3 ')

insert into tb2 values('A03'  ,  'CC' , 'Black ' ,300 ,       'A4 ')

insert into tb2 values('A04'  ,  'DD' , 'White ' ,400 ,       'A5 ')



create table tb3(OrderNo varchar(10) ,Name varchar(10),Color  varchar(10),OutAmount int,   Place varchar(10))

insert into tb3 values('A01' ,   'AA' , 'Red ' ,  20  ,        'A1 ')

insert into tb3 values('A01' ,   'AA' , 'Red ' ,  20  ,        'A1 ')

insert into tb3 values('A02' ,   'BB' , 'Bule' ,  100 ,        'A3 ')

go



select OrderNo, Name ,Color, sum(InAmount) InAmount ,  sum(AtAmount) AtAmount  ,  sum(OutAmount) OutAmount, Place from

(

select OrderNo, Name ,Color , InAmount =0 ,  AtAmount  ,  OutAmount = 0, Place from tb1

union all

select OrderNo, Name ,Color , InAmount ,  AtAmount =0 ,  OutAmount = 0, Place from tb2

union all

select OrderNo, Name ,Color , InAmount =0,  AtAmount =0 ,  OutAmount , Place from tb3

) t

group by OrderNo, Name ,Color, Place



drop table tb1,tb2,tb3



/*

OrderNo    Name       Color      InAmount    AtAmount    OutAmount   Place      

---------- ---------- ---------- ----------- ----------- ----------- ---------- 

A01        AA         Red        100         60          40          A1

A01        AA         Yellow     500         500         0           A2 

A02        BB         Bule       100         0           100         A3

A03        CC         Black      300         300         0           A4 

A04        DD         White      400         400         0           A5



（所影响的行数为 5 行）

*/

华夏小卒 2009-10-13

打赏
举报



if object_id('tb1') is not null drop table tb1

go

create table tb1(OrderNo varchar(10),Name varchar(10), Color varchar(10), AtAmount int, Place varchar(10))

insert into tb1 select

'A01',      'AA',    'Red'  ,    60  ,      'A1' union all select

'A01',      'AA',    'Yellow',  500  ,      'A2' union all select

'A02',      'BB',    'Bule'  ,  0    ,      'A3'  union all select

'A03',      'CC',    'Black' ,   300 ,       'A4' union all select

'A04',      'DD',    'White' ,   400 ,       'A5' 



if object_id('tb2') is not null drop table tb2

go

create table tb2(OrderNo varchar(10),Name varchar(10), Color varchar(10),inAmount int, Place varchar(10))

insert into tb2 select 

'A01',      'AA',      'Red'   ,   50  ,      'A1' union all select

'A01',      'AA',      'Red'   ,   50   ,     'A1' union all select

'A01',      'AA' ,     'Yellow',    500  ,      'A2' union all select

'A02',      'BB' ,     'Bule'  ,    100   ,     'A3' union all select

'A03',      'CC' ,     'BLACK'  ,    300    ,    'A4' union all select

'A04',      'DD' ,     'White',    400      ,  'A5' 





if object_id('tb3') is not null drop table tb3

go

create table tb3(OrderNo varchar(10),Name varchar(10), Color varchar(10), outAmount int, Place varchar(10))

insert into tb3 select

'A01',      'AA' ,     'Red',        20     ,   'A1' union all select

'A01',      'AA' ,     'Red' ,       20    ,    'A1' union all select

'A02',      'BB',      'Bule' ,     100   ,     'A3' 





select a.OrderNo,a.Name,a.Color,

InAmount=isnull(InAmount,0),

AtAmount=isnull(AtAmount,0),

OutAmount=isnull(OutAmount,0),a.Place  

from tb1 a

left join

(select OrderNo, Name,Color,InAmount=sum(InAmount)

from tb2 group by OrderNo, Name,Color) b

on a.OrderNo=b.OrderNo and a.Name=b.Name and a.Color=b.Color

left join 

(select OrderNo, Name,Color,outAmount=sum(outAmount)

from tb3 group by OrderNo, Name,Color)c

on a.OrderNo=c.OrderNo and a.Name=c.Name and a.Color=c.Color





OrderNo    Name       Color      InAmount    AtAmount    OutAmount   Place

---------- ---------- ---------- ----------- ----------- ----------- ----------

A01        AA         Red        100         60          40          A1

A01        AA         Yellow     500         500         0           A2

A02        BB         Bule       100         0           100         A3

A03        CC         Black      300         300         0           A4

A04        DD         White      400         400         0           A5



(5 行受影响)

dawugui 2009-10-13

打赏
举报

就是全部union all,然后group by

solarcy 2009-10-13

打赏
举报

select MaterialAtInfo .OrderNo, MaterialAtInfo .Name, MaterialAtInfo .Color, MaterialAtInfo .AtAmount, MaterialAtInfo .Place,MaterialInInfo.InAmount
,MaterialOutInfo .OutAmount from MaterialAtInfo
inner join MaterialInInfo
on
MaterialAtInfo .orderNo=MaterialInInfo.orderNo and MaterialAtInfo .Name =MaterialInInfo.Name and MaterialAtInfo .color=MaterialInInfo.color
inner join MaterialOutInfo
MaterialAtInfo .orderNo=MaterialOutInfo.orderNo and MaterialAtInfo .Name =MaterialOutInfo.Name and MaterialAtInfo .color=MaterialOutInfo.color

guguda2008 2009-10-13

打赏
举报

两个INNER JOIN搞定

luoyoumou 2009-10-13

打赏
举报

--我不是四眼青蛙，看不懂楼主的意思，
--楼主就不能说详细点？

guguda2008 2009-10-13

打赏
举报

navy887 2009-10-13

打赏
举报

昨天的那个数据搞错了,重新再开一个..

相关推荐