title: Get value from other foreign key table based on current table value
body: <p>I am working on a project where I need to extract the data from excel sheet to SQL  Server 
     , well that bit have done successfully. Now my problem is that for a particular column<br>
  called product size, I want to update current table based on product size  in other table, I am really very confused , please help me out </p>
  
  <p>Please find the table structure    </p>
  
  <pre><code>    CREATE TABLE [dbo].[T_Product](
  [ProductID] [int] IDENTITY(1,1) NOT NULL,
  [PartNo] [nvarchar](255) NULL,
  [CategoryID] [int] NULL,
  [MaterialID] [float] NULL,
  [WireformID] [float] NULL,
  [ProductName] [nvarchar](50) NULL,
  [ProductSize] [nvarchar](50) NULL,
  [ProductLength] [varchar](20) NULL,
  [ProductActive] [bit] NULL,
  [ProductImage] [varchar](60) NULL
   ) ON [PRIMARY]
  
       CREATE TABLE [dbo].[T_ProductSize](
  [Code] [int] IDENTITY(1,1) NOT NULL,
  [ProductSize] [nvarchar](50) NULL,
  [Length] [nchar](20) NULL
   ) ON [PRIMARY]
  
   GO
  </code></pre>