home *** CD-ROM | disk | FTP | other *** search
/ Chip 2000 May / Chip_2000-05_cd1.bin / tema / SW602 / Winbase / EShop_demo / OBJPOL_CENIK.CRS < prev    next >
Text File  |  2000-03-16  |  464b  |  8 lines
  1. {$$3201179080                                } {3 6 7 119 6 234 9}
  2. SELECT Obj_polozky.id_dobj,Obj_polozky.id_pol,Obj_polozky.mnozstvi,Obj_polozky.cena_sum,cenik.nazev_zbozi,S_dph.procento,cenik.kod_zbozi,Cenik.jednotka,Obj_polozky.cena_summn,Obj_polozky.nazev_vl
  3. FROM Obj_polozky, Cenik, S_dph
  4. WHERE Cenik.id_cenik=Cenik.id_cenik AND Obj_polozky.id_cnk=Cenik.id_cenik AND S_dph.id_dph=Cenik.dph
  5.  AND (S_dph.uc_rok=year(today))
  6. ORDER BY Obj_polozky.id_pol
  7.