Autor | Zpráva | ||
---|---|---|---|
kOsTEj Profil |
#1 · Zasláno: 10. 10. 2007, 16:12:12
Prosim moderatora o odstraneni stejneho vlakna z fora "JAK NECO UDELAT"... dekuji
Ahoj, nedavno jsem psal o radu s timto problemem. Odkaz Reseni od Kcka bylo v poradku: (SELECT count(id) as s4ok FROM 2007_8 WHERE s4stav='1') UNION ALL (SELECT count(id) as s4nok FROM 2007_8 WHERE s4stav='2') UNION ALL (SELECT count(id) as s5ok FROM 2007_8 WHERE s5stav='1') UNION ALL (SELECT count(id) as s5nok FROM 2007_8 WHERE s5stav='2') Ale ted bych potreboval rozsirit o hledani v dalsi tabulce. Chci se zeptat, jestli to zvladnu v soucasnem navrzeni tabulky pomoci klicoveho slova, nebo to budu muset zjistovat na 2x pro ruzne tabulky. Takto to nelze udelat:( ((SELECT count(id) as s4ok FROM 2007_8 WHERE s4stav='1') UNION (SELECT count(id) as s4ok FROM 2007_9 WHERE s4stav='1')) UNION ((SELECT count(id) as s4nok FROM 2007_8 WHERE s4stav='2') UNION (SELECT count(id) as s4nok FROM 2007_9 WHERE s4stav='2')) UNION ((SELECT count(id) as s5ok FROM 2007_8 WHERE s5stav='1') UNION (SELECT count(id) as s5ok FROM 2007_9 WHERE s5stav='1')) UNION ((SELECT count(id) as s5nok FROM 2007_8 WHERE s5stav='2') UNION (SELECT count(id) as s5nok FROM 2007_9 WHERE s5stav='2')) diky za radu |
||
Kajman_ Profil * |
select '2007_8' zdroj, sum(s4stav=1) s4ok, sum(s4stav=2) s4nok, sum(s5stav=1) s5ok, sum(s5stav=2) s5nok from 2007_8
union all select '2007_9' zdroj, sum(s4stav=1) s4ok, sum(s4stav=2) s4nok, sum(s5stav=1) s5ok, sum(s5stav=2) s5nok from 2007_9 Ale myslím, že by bylo lepší to dát do jedné tabulky, jinak se budete ptát za měsíc, jak to je pro tři tabulky a za deset let se upíšete! |
||
Časová prodleva: 17 let
|
0