数据库3个表连接查询 如何sql三张表关联查询?

如何sql三张表关联查询?选择a.*,c.temperaturealarmu gradient From ugpu checku node as a Inner Join ugpu convergeu

如何sql三张表关联查询?

选择a.*,c.temperaturealarmu gradient From ugpu checku node as a Inner Join ugpu convergeu node as b On a.id=b.id Inner Join ugpu convergeu nodeu Config as c On a.id=c.id我认为b中应该没有id。b中应该有一列与a相关,另一列与c相关,a与c无关。这样,将需要关联三个表。否则,如果不选中B,则此查询与B无关