SELECT @bProducts = SELECT "PACKAGE"."PUB"."stock"."p-code"
              FROM   "PACKAGE"."PUB"."stock"
              WHERE  "PACKAGE"."PUB"."stock"."p-code" LIKE 'B%';

SELECT "PACKAGE"."PUB"."stock"."p-code",
       "PACKAGE"."PUB"."product"."p-desc",
       "PACKAGE"."PUB"."product"."p-pack",
       "PACKAGE"."PUB"."product"."p-size",
       "PACKAGE"."PUB"."stock"."locn-post",
       "PACKAGE"."PUB"."stock"."pk-stock",
       "PACKAGE"."PUB"."stock"."pk-stock-in"
FROM   "PACKAGE"."PUB"."stock",
       "PACKAGE"."PUB"."product"
WHERE  "PACKAGE"."PUB"."stock"."depot" = 1
AND    "PACKAGE"."PUB"."stock"."p-code" NOT IN (SELECT @bProducts)
AND    "PACKAGE"."PUB"."product"."p-code" = "PACKAGE"."PUB"."stock"."p-code" WITH (nolock)