求sql

weixin_44460901 2019-08-21 11:27:16

求下面结果的sql语句，谢谢

...全文

109 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

yang_z_1 2021-01-25

打赏
举报

大佬 6666啊

李钦。 2020-09-07

打赏
举报

你结果第二行的数据错一个。应该不是6，是9

李钦。 2020-09-07

打赏
举报

给你份完整的，直接拿去执行。 create table biao1( invoice varchar(100), sales varchar(100), client varchar(100) ); create table biao2( invoice varchar(100), sku varchar(100), invoiceqty varchar(100) ); create table biao3( shelf varchar(100), sku varchar(100), batch varchar(100), shelfqty varchar(100) ); insert into biao1 values('S1908012','Ted','ABCD'); insert into biao2 values('S1908012','CD-F002875976','10'); insert into biao2 values('S1908012','CD-F002784888','20'); insert into biao2 values('S1908012','CH-126640','30'); insert into biao3 values('01-A01','CD-F002875976','DA2','4'); insert into biao3 values('01-A02','CD-F002875976','DA3','9'); insert into biao3 values('01-B56','CD-F002784888','FEW1','20'); insert into biao3 values('02-A01','CH-126640','ES3','15'); insert into biao3 values('02-A02','CH-126640','ES4','9'); select biao1.invoice,biao1.sales,biao1.client,biao2.sku,biao2.invoiceqty,biao3.shelf,biao3.shelfqty,biao3.batch from biao1,biao2,biao3 where biao1.invoice = biao2.invoice and biao2.sku = biao3.sku;

李钦。 2020-09-07

打赏
举报

select biao1.invoice,biao1.sales,biao1.client,biao2.sku,biao2.invoiceqty,biao3.shelf,biao3.shelfqty,biao3.batch from biao1,biao2,biao3 where biao1.invoice = biao2.invoice and biao2.sku = biao3.sku;