求下面結果的sql陳述句，謝謝
uj5u.com熱心網友回復：
3個表連接起來 , 最基本的SQL語法如果連這不懂, 那就不要學了.
uj5u.com熱心網友回復：
好像也不對，比如結果中的第二行……
uj5u.com熱心網友回復：
應該就是三個表連起來，連表欄位分別是Invoice、SKU。。。。不過希望表中第二行的ShelfQty寫岔了吧uj5u.com熱心網友回復：
select biao1.invoice,biao1.sales,biao1.client,biao2.sku,biao2.invoiceqty,biao3.shelf,biao3.shelfqty,biao3.batch from biao1,biao2,biao3where biao1.invoice = biao2.invoice and biao2.sku = biao3.sku;
uj5u.com熱心網友回復：
給你份完整的，直接拿去執行。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;
uj5u.com熱心網友回復：
你結果第二行的資料錯一個。應該不是6，是9轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/7115.html
標籤：PostgreSQL
上一篇：Mysql分頁查詢問題