I have a table named tblDefectCauses that contains an OpenOrdRecID and a field named DefectCauses.
If in the table using job #23904 for example we have the following in the DefectCauses field:
There are 6 records. But the are only 4 different Defect causes.
I want to write a query that will give me a result of 4 (different Defect Causes).
What would the query look like in SQL?