关于 SQLSEVER 语句的问题、求大神们解答

This topic created in 3826 days ago, the information mentioned may be changed or developed.

sqlsever

语句

解答

关于

3 replies • 2016-05-21 01:46:35 +08:00

bozong

May 21, 2016

有 A/B/C 三张表。需要得到表 D

bozong

May 21, 2016

Smilecc

May 21, 2016

SELECT A.Name,A.supportRate,C.supportRate FROM A
LEFT JOIN C ON A.Taxvalue = C.Tax AND C.EnableFlag=1
LEFT JOIN B ON B.oid = A.RefPk AND B.Entpriseid = C.Entpriseid