-----Original Message-----
From: Jeff Aley - GCD PE [mailto:jaley@pcocd2.intel.com]

I'm the wrong kind of techie (I'm a hardware guy), but I'll try to fake
it. What about

select mfr, part_number
from HO_kit
where HO_kit.prototype=orer!roster.class_id
and orer!roster.class_id='X31F'

You got the comprehensive list of accurate models & the mapping from that
list over to railroad car series numbers? I'll load it if you do. 8-)

[or something like that] ??

Ahh, the specificity of a true hardware guy! Causes one to reflect on the
meaning of life.

Dave Nelson