Click here to Skip to main content
15,749,352 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i am having 2 oracle table

one table is having one column named item

in the second table i am having item and code

while selecting the values from table one using select * i want to replace the item with their corresponding code from second table

please help

thanks in advance


1 solution

I think you mean you want do do a join on those columns. You want the code column from table2 for every item in table1. Something like this:
select table2.code 
   from table2
   inner join table1 on table1.item = table2.item;[^]

Good luck!
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900