左外部联接和附加的where子句

左外部联接和附加的where子句

是的，将条件（称为谓词）放入联接条件中

   Select [stuff]   From TableA a       Left Join TableB bOn b.Pk = a.Pk    -- [Put your condition here, like this]    And b.Column = somevalue