DELETE stockcheckfreeze
				FROM stockcheckfreeze
				INNER JOIN stockmaster ON stockcheckfreeze.stockid=stockmaster.stockid
				WHERE stockmaster.categoryid IN ('BAGS','FROZEN BASA FILLET','BEEF','BLACK FISH','CHICKEN','CRAB','FOREQUARTER LAMB','Fresh Fish Sliced','Fresh Fish Whole','FROZEN MULLET FISH','GOAT','GRADE A FISH','GRADE B FISH','GRADE C FISH','JACK FISH','LAMB','LOBSTER','MARLIN FISH','OGO FISH','PRAWN','SALAD MIX','SHRIMP','TUNA FISH','WAHOO FISH','WALU FISH')
				AND stockcheckfreeze.loccode='3'