81,092
社区成员
发帖
与我相关
我的任务
分享
select * from cat_table as table1 cat_table as table2
where table1.mate = table2.id
and table1.name like "Kit%"
跟SQL语句
select * from cat_table as table1 cat_table as table2
where table1.mate = table2.id
and table2.name like "Kit%"
查询的结果是完全不一样的呀(两个查询中最后一个条件的表一个是table1一个是table2)