Suppose you subscribe to a public email list that offers support on a
free open source database, and you see an email where someone doesn't
really provide nearly enough information to answer, what would you do?
What is the algorithm you are trying to implement to get the query-output?
Roy Harrell wrote:
Suppose I have a simple table as follows:
PartName Tolerance Cycles
A 1 10
A 2 11
A 3 13
A 4 15
A 5 18
B 1 12
B 2 14
B 3 16
B 4 16
B 5 17
C 1 6
C 2 7
C 3 7
C 4 8
C 5 10
How do I set up a query whose output would
look like this:
Tolerance PartA PartB PartC
1 10 12 6
2 11 14 7
3 13 16 7
4 15 16 8
5 18 17 10
Thanks,
Roy Harrell
Adaptive Equipment
352.372.7821
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
