Team I have I assume an array that

[acr1]

Team
I have I assume an array that I need to incorporate in my SQL query... The scenario is as follows:...

Where the defect code = 1064 and SOR is in the range 18050 - 18999 (inclusive) then the fault code = 3133

Defect SOR Range Fault Code
1064 18050 - 18999 3133
1065 18050 - 18999 3131
1066 18050 - 18999 3200
1067 18050 - 18999 3132
1068 18050 - 18999 3207
1070 18050 - 18999 3107
1072 18050 - 18999 3200
1074 18050 - 18999 3101
1076 18050 - 18999 3200

If Anyone that can supply a workable solution asap that would be greatly appreciated.. The current equal join is not going to allow this, Is their a way to run this and hold the variables in memory...or would I need to run two separate queries.. (1 for the above info and 2 for the existing query I have.)

TIA

 

[dgillz]

Is "SQR Range" one field with the text "18050-18899" in it, or is it actually a number field? Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Ngolem]

your problem is not stated very well.

Do you mean that you want an array created from SOR Range with consecutive numbers and the SOR value is determined by the Defect and Fault Codes?

All ranges of SOR are identical...What is it that you are trying to do....you state something is not possible by normal equal joins??? What isn't possible What are the table structures... Jim Broadbent