mysql query to get proper results

See more:

C#

ASP.NET

MySQL

hi all

my table like:

uid empid datetime
 1  9003  2012-09-26 09:20:00
 3  9000  2012-09-26 09:20:00
 4  9004  2012-09-26 09:20:00
 5  9002  2012-09-26 09:20:00 
 7  9001  2012-09-26 09:20:00
 18 9004  2012-09-25 09:15:00
 17 9000  2012-09-25 09:15:00
 11 9004  2012-09-26 08:59:00
 12 9002  2012-09-26 08:59:00
 15 9003  2012-09-25 09:15:00
 14 9001  2012-09-26 08:59:00
 19 9002  2012-09-25 09:15:00
 21 9001  2012-09-25 09:15:00

i have written query like

select * from attlog where TIME(datetime )>='09:00:00' and empid not in (select empid from attlog where TIME( datetime )<'09:00:00') AND DATE_FORMAT(DATE( datetime ) , '%m/%d/%Y' ) BETWEEN '09/25/2012' AND '09/26/2012' 

but i need to get datetime to check entries made after 9 but not before 9

now it is show like:

uid empid datetime
1  9003 2012-09-26 09:20:00
3  9000 2012-09-26 09:20:00
17 9000 2012-09-25 09:15:00
15 9003 2012-09-25 09:15:00

but it has to show like

uid empid datetime
1  9003 2012-09-26 09:20:00
3  9000 2012-09-26 09:20:00
18 9004 2012-09-25 09:15:00
17 9000 2012-09-25 09:15:00
15 9003 2012-09-25 09:15:00
19 9002 2012-09-25 09:15:00
21 9001 2012-09-25 09:15:00
22 9000 2012-09-25 09:15:00
23 9003 2012-09-25 09:15:00

am out of ideas... please can any one help me
thanks in advance