sql语句有错吗selecta.UnitId,a.TitleIdasTitleId,b.NameasTitleIds,e.NameasUnitBudgetTypeId,c.NameasUnitCentralDeptId,d.NameasUnitInChargeDeptId,f.NameasUnitBank1IdfromSalaryUnitsasa,FuncTitlesasb,CodeUnitBudgetTypease,CodeUni

Question

sql语句有错吗
select a.UnitId ,a.TitleId as TitleId,b.Name as TitleIds,e.Name as UnitBudgetTypeId,
c.Name as UnitCentralDeptId,d.Name as UnitInChargeDeptId,f.Name as UnitBank1Id from
SalaryUnits as a,FuncTitles as b,CodeUnitBudgetType as e,
CodeUnitCentralDept as c,CodeUnitInChargeDept as d,CodeUnitBank as f
where TitleId=b.Id and a.UnitCentralDeptId=c.Id and
a.UnitInChargeDeptId=d.Id and a.UnitBudgetTypeId=e.Id and a.UnitBank1Id=f.ID
and a.UnitId='12312'

Answer 1

如果是sql执行没有报错，只是预期的数据没有查询出来，那就是sql的条件有问题了，这个因为看不到具体数据也没法告诉你错在哪里，建议把where后面的条件一句一句执行，定位到底是哪个条件把数据筛选掉了