求一个左外连接查询语句!实在搞不定语法了
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 join ContractKind on mainContract.belong=ContractKind.ID left outer join node on mainContract.step=node.step
