Get Completed Boxes from a table

ricespn · June 24th, 2012, 12:33 PM

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 ?

ricespn · June 25th, 2012, 01:40 PM

Man Really, no one?. Thats the reason I dont like to post in forums. Everyone are looking for help but so little helpers.