Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2004

    Angry Unanswered: Can you join columns whose data type is char

    I have two tables :

    program_code | Program_name
    abc | abcdef
    Tin | Tin Tin

    Program_Code | Program_Name | Type
    tin | Tin Tin | good
    BB | Big Bang | poor

    I am trying to join the tables so as to the get program_code and Name from T1 which are present in T2 . Here is my query :
    select T1.Program_code, T1.Program_name from T1 join T2 on
    T1.Program_code = T2.Program code

    This query should yeild me : Tin | Tin Tin
    But unfortunately it doesnt. So my question is, can we join colums whose data type is char ?
    My DB is SQL SERVER 2000
    Would appreciate a quick response.


    -- Vikram
    Last edited by vikrammodi; 03-22-04 at 17:05.

Posting Permissions

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