QUERY QUESTION

From: agis <stag_at_hq.acn.gr>
Date: Fri, 22 Oct 2004 11:55:59 +0300
Message-ID: <clahv2$ukb$1@ulysses.noc.ntua.gr>

Hi to all,

I have a table like the below :

val1 val2 val3

---

81 1 121564
81 2 5616516
81 3 15/07/03
81 4
81 5 checked
81 6
81 9 checked
81 10
81 11 checked
81 12
81 13 checked
81 14
81 15 checked
81 17
81 18 checked
81 19
81 20
81 23 12
81 24
82 1 1654
82 2 4564
82 3 16/07/03
82 4 checked
82 5 checked
82 6 checked
82 9
82 10

and i want a query to have the following result set :

81 121564 5616516 15/07/03....
82 1654 4564 .....
.....

I dont need to saw val2

Can anyone help with this ?

Thanks Received on Fri Oct 22 2004 - 03:55:59 CDT