SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use look up table

453619Sep 11 2006 — edited Sep 11 2006

Hey

I have a table called SOURCES in that i have a column called STATE. Some of the rows contains data in that column as FL,NY,NJ like that and some other rows contains FLORIDA,NEWYORK..like that.

I am generating reports from that table based some criteria on STATE field,so that i need match STATE column like following.

select a.sourcename,b.sourcename from SOURCES where
a.state=b.state.

for this purpose i have created a lookup table contains state abbreviation and state descriptionLike

FL FLORIDA
NY NEWYORK

How to compare state field using that lookup table.Can any body please help me?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2006

Added on Sep 11 2006

3 comments

342 views