Salem Howdy C:\ 80%
Salem Doody C:\ 54%
Mobile Zipper D:\ 49%
Mobile Zinger C:\ 63%
Mobile Zapper C:\ 79%
Portland Alpine C:\ 85%
Portland Alpine D:\ 97%
A node caption is identified in the EOC_Node table by OrionID and NodeID. The NodeID can actually be duplicated as long its OrionID is unique.
In the EOC_Volume table
Basically what I want to do is get the name contained in the EOC_Orion table (based on OrionID) and the caption contained in the EOC_Node (based on OrionID and NodeID) for each volume in EOC_volume.