select mainContract.*,ContractKind.name from mainContract,ContractKind where mainContract.belong=ContractKind.ID left outer join node on mainContract.step=node.step思路就是这样,不过查询分析器一直报错,改过去改过来也不对,请各位大哥大姐指教一下,谢谢!
select mainContract.*,ContractKind.name from mainContract,ContractKind left outer join node on mainContract.step=node.step where mainContract.belong=ContractKind.ID
或select mainContract.*, ContractKind.name from mainContract inner join ContractKind on mainContract.belong=ContractKind.ID left join node on mainContract.step=node.step
select mainContract.*,ContractKind.name from mainContract join ContractKind on mainContract.belong=ContractKind.ID left outer join node on mainContract.step=node.step
老大 select mainContract.*,ContractKind.name from mainContract,ContractKind left outer join node on mainContract.step=node.step where mainContract.belong=ContractKind.ID 报错 列前缀 'mainContract' 与查询中所用的表名或别名不匹配。
from mainContract,ContractKind
left outer join node on mainContract.step=node.step
where mainContract.belong=ContractKind.ID
ContractKind.name
from mainContract
inner join ContractKind on mainContract.belong=ContractKind.ID
left join node on mainContract.step=node.step
select mainContract.*,ContractKind.name
from mainContract,ContractKind
left outer join node on mainContract.step=node.step
where mainContract.belong=ContractKind.ID
报错 列前缀 'mainContract' 与查询中所用的表名或别名不匹配。