SELECT
t.foo,
t.bar,
t.baz
o.foobar,
o.barfoo
FROM dbo.something AS t
INNER JOIN duo.other AS o
ON t.ID = o.SomethingID
WHERE t.foo = 123
AND o.foobar >= '2019-01-01'
AND o.foobar < '2020-01-01'
AND NOT EXISTS (
SELECT NULL
FROM dbo.lame AS l
WHERE o.ID = l.OtherID
);