home *** CD-ROM | disk | FTP | other *** search
/ PC World 2003 December / PCWorld_2003-12_cd.bin / Software / komercni / alc / ep2sr51csy.msi / Ep.CAB / q6 < prev    next >
Text File  |  2003-08-04  |  335b  |  10 lines
  1. SELECT AS "Nainstalovan² software podle poΦφtaΦ∙ (licenΦnφ)"=S "Software"=S1.@product, "Datum"=S1.@date, "Nainstaloval"=S1.@user, "Poznßmka"=S1.@description
  2. WHERE druh="sestava"
  3. WITH
  4.     SELECT SWINST AS S1 
  5. WHERE @type=SW_NEEDSLIC OR @type=SW_TRIALLIC 
  6. HAVING S1
  7. ENDWITH
  8. GROUP BY @object
  9. ORDER BY @object
  10. COUNT BY S1.@product