ai, trecias stulpelis yra? tada viskas kur kas sudetingiau

select id1, id,2, value from table
union
select id2, id1, value from table

"NicMC" <jzs@freemail.lt> wrote in message
news:ir5iec$m4t$1@trimpas.omnitel.net...
> On 2011.05.20 13:53, 2x50 wrote:
>> select id1, id2 from table
>> union
>> select id2, id1 from table
>
> Kokiu būdu šitoj vietoj išnaikinsiu 2 pradinių duomenų eilutę?
>
>>> +-------------------+
>>> | ID1 | ID2 | Value |
>>> +-------------------+
>>> |  A  |  B  |  X    |
>>> +-------------------+
>>> |  B  |  A  |  X    |
>>> +-------------------+
>>> |  C  |  B  |  X    |
>>> +-------------------+
>>> |  B  |  C  |  Y    |
>>> +-------------------+