SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE PhysicalLocation (
  LocationId INTEGER,
  LocationAddress VARCHAR(8)
);

INSERT INTO PhysicalLocation
  (LocationId, LocationAddress)
VALUES
  ('100', 'Address1'),
  ('101', 'Address2'),
  ('102', 'Address3');

CREATE TABLE Store (
  StoreID VARCHAR(4),
  LocationId INTEGER,
  Status VARCHAR(8)
);

INSERT INTO Store
  (StoreID, LocationId, Status)
VALUES
  ('100A', '100', 'Active'),
  ('100B', '100', 'Inactive'),
  ('101C', '101', 'Inactive'),
  ('102D', '101', 'Inactive');
7 rows affected

SELECT
    P.*
FROM
   PhysicalLocation P
INNER JOIN (
   SELECT LocationId
   FROM Store
   GROUP BY LocationId
   HAVING COUNT(CASE WHEN Status='Active' THEN 1 END) =0
) SA ON p.LocationId=SA.LocationId


LocationId
LocationAddress


101
Address2


Warning: Null value is eliminated by an aggregate or other SET operation.


SELECT
    P.*
FROM
   PhysicalLocation P
LEFT JOIN (
   SELECT 
       LocationId,
       COUNT(CASE WHEN Status='Active' THEN 1 END) as no_active_locations
   FROM Store
   GROUP BY LocationId
) SA ON p.LocationId=SA.LocationId
WHERE SA.no_active_locations=0 OR SA.no_active_locations IS NULL


LocationId
LocationAddress


101
Address2

102
Address3


Warning: Null value is eliminated by an aggregate or other SET operation.