如何在查询中显示重复值 [英] how can I show duplicate values in a query

问题描述

您好我在下面有一个查询。我试图在14行显示7天，这意味着每天应该有2行。工作正常

Hello I have a query below. I am trying to show 7 days in 14 rows which means that each day should have 2 rows. which works fine

SELECT  t.*
FROM    Calender AS t
        CROSS JOIN (VALUES (1), (2)) AS Number 

然而，当我与另一张桌子一起离开时，每天将再次乘以2，所以变为4行

However, when I Left Join with another table then each day will multiply by 2 again so becomes 4 rows

left outer join (
                                SELECT  distinct
                                        CONVERT(VARCHAR(10), [DateTime], 120) as StampDate
                                        ,convert(varchar(9), [DateTime], 108) AS StampTime
                                        ,x.InOut
                                        ,x.UserID
                                FROM [FTDP].[dbo].[Transaction] x
                                INNER join [FTDP].[dbo].[UserMapping] c
                                    on x.userid = c.userid
                                        and c.DomainId = @DomainId
                                ) x on A.date_id = x.StampDate
) 
ORDER BY 

还有另一种显示14行的方法，当我离开连接时它不会成​​倍增加吗？

is there another way to display 14 rows and that does not multiply when I left join?

推荐答案

T = calendar

Number =（1& 2）

X =内部查询



你的加入

T = calendar
Number = (1 & 2)
X = inner query

And your join

A.date_id = x.StampDate

A来自何处，甚至不应该运行，更不用说返回记录了！

where did A come from , this should not even run let alone return records!

这篇关于如何在查询中显示重复值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！