Multivalue field joins

From: Goog79 <rachellara1979_at_gmail.com>
Date: 29 Mar 2007 07:54:13 -0700
Message-ID: <1175180053.911864.170170@o5g2000hsb.googlegroups.com>

Hi everyone,

I've tried searching and searching and have already searched this group to no avail. Can anyone assist in how to do a join using a multivalue field in Oracle please?

For example, a field in an Order table has a multivalue field called Products, which might hold something like this:

123;234;345

The codes correspond to the primary key in the Product table, and I want to get the ProductName from the Product table now for each code (123, 234 and 345). How would I do this??? Is this a completely crazy question??? I can't find an answer anywhere and am starting to feel stupid!!!

Thanks so much in advance everyone! Received on Thu Mar 29 2007 - 09:54:13 CDT