| Line: |
|
SELECT * , VAL(DOC_NAME) AS ORDER1 FROM D:\LESSONSTV.COM\DATA\VIDEOS\VIDEO_INDEX, D:\LESSONSTV.COM\DATA\VIDEOS\LEVELS,D:\LESSONSTV.COM\DATA\VIDEOS\TYPES WHERE VIDEO_INDEX.LEVEL = LEVELS.LEVEL AND VIDEO_INDEX.TYPE = TYPES.TYPECODE ORDER BY &r_order. INTO CURSOR SEARCH |