У меня не отрабатывается запрос :

SELECT *, (SELECT name FROM names WHERE idname= computers.idname ) AS comp_idname, (SELECT name FROM names WHERE idname= computers.level ) AS comp_level, (SELECT bool FROM offices WHERE idoffice=(SELECT idoffice FROM divisions WHERE iddivision=computers.iddivision) ) AS comp_place_bool, (SELECT department FROM offices WHERE idoffice=(SELECT idoffice FROM divisions WHERE iddivision= computers.iddivision) ) AS comp_place_dep, (SELECT division FROM divisions WHERE iddivision= computers.iddivision ) AS comp_place_div, (SELECT main FROM divisions WHERE iddivision= computers.iddivision ) AS comp_place_main, (SELECT bool FROM offices WHERE idoffice=(SELECT idoffice FROM divisions WHERE iddivision=computers.chief) ) AS comp_chief_bool, (SELECT department FROM offices WHERE idoffice=(select idoffice from divisions where iddivision= computers.chief) ) AS comp_chief_dep, (SELECT division FROM divisions WHERE iddivision= computers.chief ) AS comp_chief_div, (SELECT main FROM divisions WHERE iddivision= computers.chief ) AS comp_chief_main, (SELECT type FROM monitors WHERE idmonitor= computers.idmonitor ) AS comp_mon_type, (SELECT screen FROM monitors WHERE idmonitor= computers.idmonitor ) AS comp_mon_screen, (SELECT printer FROM printers WHERE idprinter= computers.idprinter ) AS comp_printer, (SELECT inkwell FROM inkwells WHERE idinkwell=(SELECT idinkwell FROM printers WHERE idprinter=computers.idprinter)) AS comp_inkwell, (SELECT keyboard FROM keyboards WHERE idkeyboard= computers.idkeyboard) AS comp_keyboard, (SELECT mouse FROM mouses WHERE idmouse= computers.idmouse) AS comp_mouse FROM computers ORDER BY comp_idname

***
Запрос к access 97 почему ума не приложу !
Не хочет работать из-за ORDER BY без него работает.
Кто нибудь может помочь ?

Заранее благодарен !
________________________
С УВАЖЕНИЕМ,
KID.