SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
|
Alati teme | Način prikaza |
|
06. 09. 2011. | #1 |
Ivan Dilber
Sir Write-a-Lot
|
evo ovako:
Kôd:
SELECT t1.id1, t1.id2, IF(t2.id1, (t1.broj + t2.broj), t1.broj) AS broj FROM proba t1 LEFT JOIN proba t2 ON (t1.id1 = t2.id2 AND t1.id2 = t2.id1)
__________________
Leadership is the art of getting people to want to do what you know must be done. |
06. 09. 2011. | #2 |
VD IT Direktora
Invented the damn thing
Datum učlanjenja: 08.06.2005
Lokacija: Beograd
Poruke: 2.118
Hvala: 503
1.307 "Hvala" u 282 poruka
|
Nisam siguran da razumem ideju:
Kôd:
test=# create table dpt (id1 integer, id2 integer, broj integer); CREATE TABLE test=# insert into dpt values (1, 2, 10); INSERT 0 1 test=# insert into dpt values (1, 2, 10); INSERT 0 1 test=# insert into dpt values (2, 1, 10); INSERT 0 1 test=# insert into dpt values (2, 1, 10); INSERT 0 1 test=# insert into dpt values (1, 3, 10); INSERT 0 1 test=# SELECT t1.id1, t1.id2, t1.broj + coalesce(t2.broj, 0) AS broj FROM dpt t1 LEFT JOIN dpt t2 ON (t1.id1 = t2.id2 AND t1.id2 = t2.id1); id1 | id2 | broj -----+-----+------ 1 | 2 | 20 1 | 2 | 20 1 | 2 | 20 1 | 2 | 20 1 | 3 | 10 2 | 1 | 20 2 | 1 | 20 2 | 1 | 20 2 | 1 | 20 (9 rows)
__________________
blog |
|
|