title: SQL Legacy Joins
body: <p>I'm looking at some of the older SQL code and I'm wondering what would be the proper way to convert this batch into current SQL syntax. I appreciate your help.</p>
  
  <pre><code>    If @Type = 'Edit'  
      Begin
          If @Area = 'Box'
              Declare CursorInv Cursor For 
                  Select Retention_Code, 
                      Company_Id, 
                      Department_Id, 
                      Group_Id, 
                      Section_Id, 
                      Locator_Id, 
                      Location_Current, 
                      Location_Home, 
                      Box_User_Defined1.Udf_Code User_Defined1, 
                      Box_User_Defined2.Udf_Code User_Defined2, 
                      Box_User_Defined3.Udf_Code User_Defined3
          From Box, Box_User_Defined1, Box_User_Defined2, Box_User_Defined3
          Where Box_Number = @KeyValue And 
                  Box.User_Defined1 *= Box_User_Defined1.ID And 
                  Box.User_Defined2 *= Box_User_Defined2.ID And 
                  Box.User_Defined3 *= Box_User_Defined3.ID
  </code></pre>