为什么mysql查询出来很多重复值_SQL 查询出来的结果为什么会重复

我的数据表是这样的，UNTI_2只有21条记录，但通过下面查询语句查出来近一千多条记录，重复了多次，具体如下：原数据表结构DTUNITVALUE2014-04-1110:15:00.000UNTI_1392014-04-1211:15...

我的数据表是这样的，UNTI_2只有21条记录，但通过下面查询语句查出来近一千多条记录，重复了多次，具体如下：

原数据表结构

DT UNIT VALUE

2014-04-11 10:15:00.000 UNTI_1 39

2014-04-12 11:15:00.000 UNTI_1 40

2014-04-13 12:15:00.000 UNTI_1 41

2014-04-14 13:15:00.000 UNTI_1 42

2014-04-02 01:05:00.000 UNTI_2 10

2014-04-02 01:15:00.000 UNTI_2 12

2014-04-02 01:25:00.000 UNTI_2 14

2014-04-03 02:35:00.000 UNTI_1 26

2014-04-03 02:55:00.000 UNTI_1 28

2014-04-02 01:35:00.000 UNTI_2 16

2014-04-02 01:55:00.000 UNTI_2 18

2014-04-03 02:05:00.000 UNTI_2 20

2014-04-03 02:15:00.000 UNTI_2 22

2014-04-03 02:25:00.000 UNTI_2 24

2014-04-03 02:35:00.000 UNTI_2 26

2014-04-03 02:55:00.000 UNTI_2 28

2014-04-03 03:15:00.000 UNTI_2 30

2014-04-03 03:25:00.000 UNTI_2 32

2014-04-04 04:25:00.000 UNTI_2 34

2014-04-04 04:35:00.000 UNTI_2 35

2014-04-04 05:15:00.000 UNTI_2 35

2014-04-05 05:35:00.000 UNTI_2 35

2014-04-05 06:15:00.000 UNTI_2 35

2014-04-06 06:25:00.000 UNTI_2 35

2014-04-07 06:35:00.000 UNTI_2 35

2014-04-10 07:15:00.000 UNTI_2 37

2014-04-10 08:15:00.000 UNTI_2 37

查询语句：

select a.dt as dt1 , a.unit as unit1 ,a.value as unit1value from [TEST].[dbo].[Table_2]as a , [TEST].[dbo].[Table_2]as b where a.unit='UNTI_2'AND b.unit='UNTI_1'

请高手帮看看

在上面的语句中加入 distinct正常，但在下面的语句中又开始重复

select distinct a.dt as dt1 , a.unit as unit1 ,a.value as unit1value , b.dt as dt1 , b.unit as unit2 ,b.value as unit1value from [TEST].[dbo].[Table_2]as a , [TEST].[dbo].[Table_2]as b where a.unit='UNTI_2'AND b.unit='UNTI_1'

展开