請看看我的sql語句該如何寫,錯在哪?謝謝!

[royvb]

select a.* ,m_customer.m_name from (select jq_no, jq_cl,m_manufatory.m_name from jq_base,m_manufatory where jq_base.jq_manufatory=m_manufatory.m_no ) a left join m_customer on a.jq_cl=m_customer.m_no

[royvb]

自己已查明!解決!

[lhsxsh]

ss

[dawugui]

--语法上未看出有错误.
select a.* , m_customer.m_name from 
(select jq_no, jq_cl,m_manufatory.m_name from jq_base,m_manufatory where jq_base.jq_manufatory=m_manufatory.m_no ) a 
left join m_customer 
on a.jq_cl=m_customer.m_no  

[lhsxsh]

select a.* ,m_customer.m_name
from (select jq_no, jq_cl,m_manufatory.m_name from jq_base inner join ,m_manufatory on jq_base.jq_manufatory=m_manufatory.m_no ) a
left join m_customer on a.jq_cl=m_customer.m_no
试试看

[lhsxsh]

你写的SQL太有型了
很难很不好读懂

[wzy_love_sly]

顶顶

[heshengfen123]

语法没错误
你把语句放到查询分析器分析一下就行了呗

[pt1314917]

语法没错误