home *** CD-ROM | disk | FTP | other *** search
/ Chip 2000 May / Chip_2000-05_cd1.bin / tema / SW602 / Winbase / EShop_demo / VYB_DCENIK2.CRS < prev    next >
Text File  |  2000-03-16  |  348b  |  6 lines
  1. {$$3201179223                                }{4 10 10 119 4294967291 226 10 330 11}
  2. SELECT Cenik.*,S_dph.*,S_zbozi_sk.*,cenik.*
  3. FROM CENIK, S_DPH, S_ZBOZI_SK
  4. WHERE S_zbozi_sk.ID_SKUPINY=Cenik.SKUPINA_ZBOZI AND S_dph.ID_DPH=Cenik.DPH
  5.  AND (S_dph.uc_rok=year(today) AND S_zbozi_sk.vybrano=true)
  6. ORDER BY S_zbozi_sk.kod_skupiny,cenik.nazev_zbozi