大家帮个忙！

[cc9638895]

1.我现在想让我的表 按class_id的正序 addtime的倒序排列！？如何写SQL
strsql="select * from bookcity_book order by class_id"
2 怎么样同时打开2个表，因为我想用到2个表的字段！？

[chinesun]

1,
strsql="select * from bookcity_book order by class_id,addtime desc"

2,
strsql="select a.ziduan1,b.ziduan2 from table1 as a,table2 as b"

[cc9638895]

第2句不好使啊！！
strsql="select * from bookcity_book order by class_id,addtime desc"
就这句！但我下面还要用到bookcity_class里的book_class这个字段！如何写

[lions911]

1,
strsql="select * from bookcity_book order by class_id,addtime desc"

2,
strsql="select a.ziduan1,b.ziduan2 from table1 as a,table2 as b"
=================================================================
完全正确。

[cc9638895]

strsql="select a.* ,b.* from bookcity_book as a,bookcity_class as b
order by class_id, addtime desc"
你们说这样写对吗？

[cc9638895]

a , b代表什么？表？

[hohott]

a,b代表表的名字，但是a和b之间没有联系，好像不行的。一般是这样

select a.* ,b.* from a outer join b where a.字段＝ b.字段 order by a.class_id, addtime desc

[ygghost]

select a.* ,b.* from a outer join b on a.字段＝ b.字段 order by a.class_id, addtime desc

[swich]

1、select * from bookcity_book order by class_id,addtime desc

2、select a.* ,b.* from a outer join b on a.字段＝ b.字段 order by a.class_id, addtime desc