--declare @packageId as int
--set @packageId = 103451

select
	ptype.[Code]				[PackageCode]
	, ptype.[Description]		[PackageCodeDescr]
	, ptype.[Boxline Box Size]	[BoxSize]
	, header.[Item No_]			[ItemNo]
	, itm.[Description]			[ItemDescr]
from [Green Circle Growers$GCG Package Header] header (nolock)
	, [Green Circle Growers$GCG Package Type] ptype (nolock)
	, [Green Circle Growers$Item] itm (nolock)
where header.[Package Code] = ptype.[Code]
and	ptype.[Package Type] = 1
and header.[No_] = @packageId
and itm.[No_] = header.[Item No_]