This discussion is archived
11 Replies Latest reply: Mar 21, 2013 2:29 AM by chris227 RSS

how to inner join 2 different data types

998020 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points