我用下列语句对SQL2000对三个表查询进行查询有效,但对对三个表查询ACCESS却无效。请教各位:
select t1.tcol1,t1.col2,t2.col1,t2.col2,t3.col1,t3.col2 from Table1 t1
inner join Table2 t2 on t1.tcol1=t2.col1
inner join Table3 t3 on t1.tcol1=t3.col1
...全文
34回复打赏收藏
我用语句对SQL2000对三个表查询进行查询有效,但对对三个表查询ACCESS却无效
我用下列语句对SQL2000对三个表查询进行查询有效,但对对三个表查询ACCESS却无效。请教各位: select t1.tcol1,t1.col2,t2.col1,t2.col2,t3.col1,t3.col2 from Table1 t1 inner join Table2 t2 on t1.tcol1=t2.col1 inner join Table3 t3 on t1.tcol1=t3.col1