select TableA.*, TableB.*, TableC.*; > from TableA ; > Left Outer Join TableB ; > on TableA.Ident = TableB.Ident ; > and TableA.FKey = TableB.FKey ; > Left Outer Join TableC ; > on TableA.Ident = TableC.Ident ; having (isnull(TableB.FiltB) or TableB.FiltB = 1); > and (isnull(TableB.FiltC) or TableB.FiltC = 1) >>