Home Sign Up Sign In
bozong
V2EX  ›  问与答

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

  •   
  •   bozong · May 21, 2016 · 1699 views
    This topic created in 3676 days ago, the information mentioned may be changed or developed.
  • sqlsever
  • 语句
  • 解答
  • 关于
    3 replies  •  2016-05-21 01:46:35 +08:00
    bozong
        1
    bozong  
    OP
       May 21, 2016
    有 A/B/C 三张表。需要得到表 D
    bozong
        2
    bozong  
    OP
       May 21, 2016
    Smilecc
        3
    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
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1157 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 32ms · UTC 18:05 · PVG 02:05 · LAX 11:05 · JFK 14:05
    ♥ Do have faith in what you're doing.