Advertisement
Guest User

Untitled

a guest
Sep 30th, 2014
321
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.35 KB | None | 0 0
  1. SELECT DISTINCT "upom_poz"."fk_soplaty","oplaty".*,
  2. "wipo".fu_odsetki(oplaty.termin,CURRENT_DATE,0,oplaty.kwota,FALSE,CAST(upom_poz.fk_soplaty AS INT),'GOK')AS "odsetki" FROM
  3. "wipo"."upom_poz" "upom_poz" JOIN
  4. (SELECT "id","fk_podatek","termin","kwota" FROM "wipo"."oplaty")"oplaty" ON "upom_poz"."fk_soplaty"="oplaty"."id" WHERE "upom_poz"."fk_soplaty"=198745
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement