SQL有关问题

SQL问题
大家好我是一个新手
请大家帮个忙
我相按间时排序
  sql= "select     *   from   SMT_news   where   SMT_newssort= "&id  
不知应写在哪
请大家帮个忙
谢了

[解决办法]
sql= "select * from SMT_news where SMT_newssort= "&id & " order by 时间字段 "
[解决办法]
写在最后
sql= "select * from SMT_news where SMT_newssort= "&id & " order by [time]