Hi guys,
I have the folloing table:
docID, boxNumber, docCompleted
1235, box01, true
1234, box01, true
1233, box01, false
1245, box02, true
1987, box03, true
1097, box06, false
I'm trying to use a Distinct to display the box number that have been competed. If I do my query like so:
Code:
Select distinct(boxNumber) from table1 where docCompleted=true
but that will list box01 even tho one docID (1233) is not completed.
Any help ?