Advertisement
Guest User

Untitled

a guest
Aug 21st, 2014
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT *
  2. FROM (
  3. SELECT SUM(pvp.PODIL_CITATEL / pvp.PODIL_JMENOVATEL) AS suma
  4. FROM PU_VLA_P pvp
  5. JOIN (SELECT DISTINCT (ppp.TEL_ID)
  6. FROM PU_PARP ppp) ON tel_id = pvp.tel_id and pvp.TYPRAV_KOD = 30
  7. )
  8. WHERE suma != 1;
  9.  
  10. SELECT SUM(res.PODIL_CITATEL / res.PODIL_JMENOVATEL) AS suma
  11. FROM PU_PARP AS pp
  12. INNER JOIN
  13. (((SELECT DISTINCT(ppp.TEL_ID)
  14. FROM PU_PARP ppp) AS dist)
  15. INNER JOIN PU_VLA_P AS pvp
  16. ON dist.TEL_ID = pvp.TEL_ID) AS res
  17. WHERE res.TYPRAV_KOD = 30
  18. AND suma != 1
  19.  
  20. v podstate mas dve tabulky PU_PARP a PU_VLA_P
  21. a ukolem je projet unikatni TEL_ID (proto DISTINC())
  22. a ty pouzit na tu druhou tabulku
  23. a tam scitat ty podily
  24. a chci jenom ty zaznamy, kde soucet neni 1
  25. a chyba je "Syntaktická chyba v klauzuli FROM."
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement