Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Posts
    12

    Unanswered: Joining 2 tables

    I have 2 table Temp_Model,Txt_Temp. in Temp_Model i have ModelCodel and Modelname
    and Txt_Temp ModelCode and should get result with ModelName with respect to Model Code.
    below i have given details of table.
    Thanks.

    Temp_Model
    Model_Id Model_Code Model_Name
    1 IHA Mohavi
    2 A7F Credenza
    3 MJK Picanto

    Txt_Temp
    Model_Code VinNumber
    IHA 464057
    IHA 936832
    IHA 464027
    A7F 231114
    A7F 897308
    A7F 283948
    A7F 897262
    A7F 897316

    I need the result like this
    VinNumber Model_Code Model_Name
    464057 IHA Mohavi
    936832 IHA Mohavi
    464027 IHA Mohavi
    231114 A7F Credenza
    897308 A7F Credenza
    283948 A7F Credenza
    897262 A7F Credenza
    897316 A7F Credenza

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What have you tried?
    George
    Home | Blog

  3. #3
    Join Date
    Jul 2010
    Posts
    12
    Thanks i got the answer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •