Hi,
One way of doing it would be:
select a.tolerance, a.Cycles as PartA, b.Cycles as PartB, c.Cycles as PartC
from t as a, t as b, t as c where a.tolerance=b.tolerance and
a.tolerance=c.tolerance and a.PartName='A' and b.PartName='B' and
c.PartName='C';
Jacek
-Original Message-
Yes, agreed. The case you mentioned about missing tolerance is
not in his example though - we clearly need more input from Roy.
Jacek
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 04, 2005 12:56 PM
To: Becla, Jacek
Cc: Roy Harrell