Hi, I got a problem on how to create a query on my data, where I want to get the item which is having a 'busy' and not having a 'complete' value.
Sample data Number reason 1 busy 2 complete 1 complete 2 complete 3 busy 4 complete 5 complete 3 busy all I want to get is the number which doesn't have any complete entry on reason field I know it's a sql query question, hope anyone can spare me solution on this R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No. (Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
