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" + "B" NOT IN
       (
              SELECT "PACKAGE"."PUB"."stock"."p-code"
              FROM   "PACKAGE"."PUB"."stock"
              WHERE  "PACKAGE"."PUB"."stock"."p-code" LIKE "B%")
AND    "PACKAGE"."PUB"."product"."p-code" = "PACKAGE"."PUB"."stock"."p-code" WITH (nolock)