home *** CD-ROM | disk | FTP | other *** search
/ Chip 2000 May / Chip_2000-05_cd1.bin / tema / SW602 / Winbase / EShop_demo / SEZNAM_TAB.CRS < prev    next >
Text File  |  2000-03-16  |  219b  |  7 lines

  1. SELECT T2.tab_name,Ord(T2.category) AS CATEG,T1.obj_name AS APL
  2. FROM OBJTAB T1, TABTAB T2 , SYS_PAR T3 
  3. WHERE T1.APL_UUID=T2.APL_UUID
  4.  AND (Ord(T1.category)=CATEG_APPL)  AND (t1.obj_name=t3.aplname)
  5. ORDER BY apl
  6.  
  7.