我有以下 sql 查詢，它連接了兩列上的兩個 select 陳述句
SELECT * FROM
(SELECT TOP(100)
Name
,ItemNum
,TicketNum
FROM [dbo].[dd]
) t1
JOIN
(SELECT TOP (100)
TicketNum
,ItemNum
FROM [dbo].[dd]) t2
ON t1.ItemNum = t2.ItemNum
AND t1.TicketNum = t2.TicketNum
該查詢產生以下輸出。
| 姓名 | ItemNum |TicketNum |TicketNum |ItemNum |
但我希望輸出為 | 姓名 | 專案編號 |票編號 |
uj5u.com熱心網友回復：
解決方案 1： 像這樣指定列名
SELECT
t1.Name, t1.ItemNum, t1.TicketNum
FROM (
SELECT TOP 100
Name, ItemNum, TicketNum
FROM [dbo].[dd]
) t1
INNER JOIN (
SELECT TOP 100
TicketNum, ItemNum
FROM [dbo].[dd]
) t2 ON t1.ItemNum = t2.ItemNum
AND t1.TicketNum = t2.TicketNum
解決方案2：
SELECT t1.* FROM (
SELECT TOP 100
Name, ItemNum, TicketNum
FROM [dbo].[dd]
) t1
INNER JOIN (
SELECT TOP 100
TicketNum, ItemNum
FROM [dbo].[dd]
) t2 ON t1.ItemNum = t2.ItemNum
AND t1.TicketNum = t2.TicketNum
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/448976.html