11 Replies Latest reply: Mar 21, 2013 4:29 AM by chris227 RSS

    how to inner join 2 different data types

    998020
      I have 2 tables. and i want to get the branch name from table2..but the thing is
      i have 2 different data type to link or join the two tables.
      tbl1
      - user
      - branch_id (number) ex. 1,2,3..

      tbl2
      -branch_code (varchar2) ex. 001, 002, 003...
      - branch_name