select 名字,DateA, a1, a2, DateB, B1, B2, DateC, C1 ,C2, C3 from A1,B1,C1 where Datea between startime and endtime or DataB between startime and endtime or DataC between startime and endtime 你试试??
SELECT A1.Name,DateA,a1,a2,DateB,B1,B2,DateC,C1,C2,C3 FROM A1 FULL JOIN B1 ON A1.Name = B1.Name AND A1.DateA = B1.DateB FULL JOIN C1 ON B1.Name = C1.Name AND B1.DateB = C1.DateC没有测试过。
select Name as 名字, DateA ,a1,a2,null,null,null,null,null,null, nullfrom a1 union select Name,null,null,null,Dateb,b1,b2,null,null,null,null from b1 union select Name,null,null,null,null,null,null,Datec ,c1,c2,c3 from c1
SELECT ISNULL(ISNULL(A1.Name,B1.Name),C1.Name) Name,ISNULL(ISNULL(DateA,DateB),DateC) Date,a1,a2,B1,B2,C1,C2,C3 FROM A1 FULL JOIN B1 ON A1.Name = B1.Name FULL JOIN C1 ON B1.Name = C1.Name
FROM A1
FULL JOIN B1 ON A1.Name = B1.Name AND A1.DateA = B1.DateB
FULL JOIN C1 ON B1.Name = C1.Name AND B1.DateB = C1.DateC没有测试过。
union
select Name,null,null,null,Dateb,b1,b2,null,null,null,null from b1
union
select Name,null,null,null,null,null,null,Datec ,c1,c2,c3 from c1
FROM A1
FULL JOIN B1 ON A1.Name = B1.Name
FULL JOIN C1 ON B1.Name = C1.Name