|
|
| Тема |
 ah tozi SQL - mislia che si gotov [re: Kiril Hadjiew] |
|
| Автор |
T () |
|
| Публикувано | 23.08.00 14:17 |
|
|
|
namerih pak malko vreme za teb
imam slednite danni v tabliza TOVAR db=ST
dat tovar kol
1 1 10
1 2 25
2 1 15
SELECT Tovar.Tovar, SUM( Tovar.Kol ) Tovar."SUM OF Kol", SUM( Tovar_1.Kol )
FROM "tovar.db" Tovar
LEFT OUTER JOIN "tovar.db" Tovar_1
ON (Tovar.Tovar = Tovar_1.Tovar AND Tovar_1.Dat = 1 AND Tovar.Dat = 1)
GROUP BY Tovar.Tovar
kazva
tovar sumobsto sumdat(za dat=1)
1 15 10
2 25 25
ostava da si opravish datata
| |
| |
| 
|
|
