I need to write a view that joins part numbers in one table to a wom_id in another. The problem is the part numbers are crammed into a single column and delimited by "|". Is it possible to write a view on top of this join, that will normalize the result?
Here is my query:
Here is the result:
I'd like to create a view that looks like this:
Is this possible?
Thanks,
Mike
Here is my query:
Code:
Select w.wom_id, c.common_config_part_nos
from wom w, global_content c
Where c.global_content_id = w.global_content_id
and c.common_config_part_nos IS NOT NULL;
Here is the result:
Code:
wom_id common_config_part_nos
973 777317-2010|777318-120|777318-110|777318-301|777318-401|777318-200|778617-04|778618-01|778805-90
1095 777318-423|777317-2120|778617-04|778618-01|778805-90
I'd like to create a view that looks like this:
Code:
wom_id common_config_part_nos
973 777317-2010
973 777318-120
973 777318-110
973 777318-401
973 777318-200
Is this possible?
Thanks,
Mike