Get Completed Boxes from a table

ricespn · #1 (**permalink**) 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 · #2 (**permalink**) 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Completed exercise files?	thorwm	BOOK: Beginning Microsoft Visual C# 2008 ISBN: 978-0-470-19135-4	8	February 25th, 2009 09:57 PM
Check boxes to appear with Table Names	hewstone999	Access VBA	1	March 13th, 2008 10:51 AM
Anyone successfully completed the book?	asptwodev	BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0	0	November 18th, 2006 10:17 AM
Anyone have completed recipes?	efireb33	Dreamweaver (all versions)	1	November 15th, 2004 05:57 PM