----------------------------------------------
| Date | TimeIn | CardNumber | TimeOut |
----------------------------------------------
2002-05-02 |21:30:12 | 13543451 | 21:30:12
2002-05-02 |21:30:22 | 13543451 | 21:30:22
2002-05-02 |21:30:48 | 45634546 | 21:30:48
2002-05-02 |21:30:55 | 45634546 | 21:30:55
2002-05-02 |21:31:19 | 45634546 | 21:31:19
2002-05-02 |21:31:59 | 13543451 | 21:31:59
2002-05-02 |21:32:06 | 13543451 | 21:32:06
2002-05-02 |21:32:08 | 13543451 | 21:32:08


hello guys i have a table above, i want to query the table and select only the firt TIMEIN and the last TIMEOUT base on their CardNumber and Date and sacde in to another table...i want to have an output like this

----------------------------------------------
| Date | TimeIn | CardNumber | TimeOut |
----------------------------------------------
2002-05-02 |21:30:12 | 13543451 | 21:32:09 |
2002-05-02 |21:30:48 | 45634546 | 21:31:19 |

i'll be very thankfull if can somebody provide me a sample code

You can this several ways

One way is to do a union, with one query returning the first, and the other query returning the last.
Select * From ThisTable Where TimeIn = (Select Max(TimeIn) From ThisTable)
Union
Select * From ThisTable Where TimeOut = (Select Max(TimeOut) From ThisTable)

Of course, this doesn't take into account that there might be two records with exaclty the same time in or time out, and therefore you need to further limit the result for each select in the union to return only the "Top 1" record. This is done differenlty depending on the db you are using.

Woody Z http://www.learntoprogramnow.com