Thanks for reply

yes both the ID field contains alphanumeric value.

like "001","002" etc

Thanks

Peter

Hello,

Thanks for reply

here is the details

Table creation script for TA

CREATE TABLE [dbo].[TA](

[ID] [nvarchar](13) NOT NULL,

[Cat1] [nvarchar](6) NULL,

[Cat2] [nvarchar](6) NULL,

[name1] [nvarchar](100) NULL,

[name2] [nvarchar](100) NULL,

CONSTRAINT [PK_cd_web_product] PRIMARY KEY CLUSTERED

(

[UPC] ASC

)WITH...