set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go create PROCEDURE [dbo].[StpListBarcode] AS SELECT BarcodeTbl.GoodCode, BarcodeTbl.Field1, BarcodeTbl.Field2, BarcodeTbl.SysId, StockTbl.Code AS PartNoCode, StockTbl.BarCode, BarcodeTbl.Quantity FROM BarcodeTbl INNER JOIN StockTbl ON BarcodeTbl.GoodCode = StockTbl.GoodSyscode