这是我得到的以下错误：
错误：在上下文中指定了非布尔类型的表达式，而上下文中的“and”附近需要条件。

select p.BusinessEntityID, p.FirstName, p.LastName, bea.BusinessEntityID, bea.AddressID
from Person.Person as p
left join
Person.BusinessEntityAddress as bea on 
p.BusinessEntityID = bea.BusinessEntityID
where bea.BusinessEntityID and bea.AddressID is NOT NULL