我用两个表查询
结果却是双份,为什么啊
[code=SQL][select t_RepairMan.id,t_RepairMan.ManID,t_RepairMan.ManName,t_RepairMan.Mobile,t_RepairMan.GroupName,
t_RepairMan.PositionName,t_RepairMan.StateName,t_RepairMan.Re,t_RepairMan.IsDel,
t_WorkInitPlan_Item_Detail_Gz.ItemID, t_WorkInitPlan_Item_Detail_Gz.ItemName,
t_WorkInitPlan_Item_Detail_Gz.RepairManName, t_WorkInitPlan_Item_Detail_Gz.ServerManName,
t_WorkInitPlan_Item_Detail_Gz.PaiGongNo, ((CONVERT(numeric(18, 2),EndTimeHours)-convert(numeric(18, 2),StartTimeHours))
+ ((CONVERT(numeric(18, 2),EndTimeMinutes) - CONVERT(numeric(18, 2),StartTimeMinutes)))/60) /8 AS TotalTime
from t_WorkInitPlan_Item_Detail_Gz,t_RepairMan/code]
结果却是双份,为什么啊
[code=SQL][select t_RepairMan.id,t_RepairMan.ManID,t_RepairMan.ManName,t_RepairMan.Mobile,t_RepairMan.GroupName,
t_RepairMan.PositionName,t_RepairMan.StateName,t_RepairMan.Re,t_RepairMan.IsDel,
t_WorkInitPlan_Item_Detail_Gz.ItemID, t_WorkInitPlan_Item_Detail_Gz.ItemName,
t_WorkInitPlan_Item_Detail_Gz.RepairManName, t_WorkInitPlan_Item_Detail_Gz.ServerManName,
t_WorkInitPlan_Item_Detail_Gz.PaiGongNo, ((CONVERT(numeric(18, 2),EndTimeHours)-convert(numeric(18, 2),StartTimeHours))
+ ((CONVERT(numeric(18, 2),EndTimeMinutes) - CONVERT(numeric(18, 2),StartTimeMinutes)))/60) /8 AS TotalTime
from t_WorkInitPlan_Item_Detail_Gz,t_RepairMan/code]
where t_RepairMan.id=t_WorkInitPlan_Item_Detail_Gz.id
你是想做个连接吧,结果你的连接条件呢?要么用..join..,要么用where条件
t_RepairMan.PositionName,t_RepairMan.StateName,t_RepairMan.Re,t_RepairMan.IsDel,
t_WorkInitPlan_Item_Detail_Gz.ItemID, t_WorkInitPlan_Item_Detail_Gz.ItemName,
t_WorkInitPlan_Item_Detail_Gz.RepairManName, t_WorkInitPlan_Item_Detail_Gz.ServerManName,
t_WorkInitPlan_Item_Detail_Gz.PaiGongNo, ((CONVERT(numeric(18, 2),EndTimeHours)-convert(numeric(18, 2),StartTimeHours))
+ ((CONVERT(numeric(18, 2),EndTimeMinutes) - CONVERT(numeric(18, 2),StartTimeMinutes)))/60) /8 AS TotalTime
from t_RepairMan left join t_WorkInitPlan_Item_Detail_Gz on t_RepairMan.ItemID=t_WorkInitPlan_Item_Detail_Gz.ItemID