Re: QUERY QUESTION

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1098551190.828827_at_yasure...
> agis wrote:
>
>> 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
>
> If you have a table like that then you were not paying attention
> when your instructor explained relational theory to you. No one
> with any understanding of any relational database would put an
> integer, string, and date into a single column.
>
> Fix your schema and the solution is self-evident.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)

I agree with u , but i did not create the table.

It was created for a developer in the creation time of the db when i was not involeved !!!!!

I have a found a solution about that !!!!

Thanks to all Received on Mon Oct 25 2004 - 03:00:27 CDT