我的表结构如下主业务表(tab_operation)
ID (PK,int,not null)
ID_operation_sort(int) //单据性质
ID_company (int) //发生关系的公司
Income (money) //销售/折款收入
ID_transport_company(int) //货运公司
Other (nvarchar(50)) //备注公司表(tab_company)
ID (PK,int,not null)
CompanyName (nvarchar(50))目前的问题是ID_company和ID_transport_company都要参考公司表tab_company
结果CompanyName重复以前的SQL语句(报错)
select * from tab_operation
Inner Join tab_company on tab_operation.ID_company=tab_company.ID
Inner Join tab_company on tab_operation.ID_transport_company=tab_company.ID
ID (PK,int,not null)
ID_operation_sort(int) //单据性质
ID_company (int) //发生关系的公司
Income (money) //销售/折款收入
ID_transport_company(int) //货运公司
Other (nvarchar(50)) //备注公司表(tab_company)
ID (PK,int,not null)
CompanyName (nvarchar(50))目前的问题是ID_company和ID_transport_company都要参考公司表tab_company
结果CompanyName重复以前的SQL语句(报错)
select * from tab_operation
Inner Join tab_company on tab_operation.ID_company=tab_company.ID
Inner Join tab_company on tab_operation.ID_transport_company=tab_company.ID
Inner Join tab_company on tab_operation.ID_company=tab_company.ID
AND tab_operation.ID_transport_company=tab_company.ID
这样呢?
Inner Join tab_company on tab_operation.ID_company=tab_company.ID)a Inner Join tab_company on a.ID_transport_company=tab_company.ID)b没测试过..
Inner Join tab_company AS B on A.ID_company=B.ID
Inner Join tab_company AS C on A.ID_transport_company=C.ID
Inner Join tab_company AS B on A.ID_company=B.ID
Inner Join tab_company AS C on A.ID_transport_company=C.ID
Inner Join tab_company AS B on A.ID_company=B.ID
Inner Join tab_company AS C on A.ID_transport_company=C.ID
用as给这两个表名重命名,应该就不会错了