asp与access数据库多表查询

sql="select * from text1 join text2 on text1.text_worker=text2.text_worker where text1.text_worker='" &user_session& "' order by text1.text_time desc"
on 表1.b=表2.b where 表1.a="5" text1和text2分别表示两个表text1.text_worker表示表1的text_worker的字段这段代码是意思是用两个表以相同的text_worker字段关联，并且表1的text_worker字段等于&user_session&

select text1.*, text2.* from text1 inner join text2 on text1.id = text2.id where text1.text_worker=’“&user_session&”‘ order by text1.text_time desc"
你最好把表格里的栏目都贴出来，我也只能假设你text1和text2里面有个自动的ID

sql="select * from text1,text2 where text1.text_work=text2.text_work and text1.text_worker='" &user_session& "' order by text_time desc"这样试试