"select a.*,b.* from tb_Card as a join tb_Module as b on a.ModuleID=b.Module
问题描述:
"select a.*,b.* from tb_Card as a join tb_Module as b on a.ModuleID=b.Module
答
select a.*,b.* from tb_Card as a join tb_Module as b on a.ModuleID=b.Module
这句等效于
"select a.*,b.* from tb_Card a,tb_Module b where a.ModuleID=b.Module
查询俩表中 a.ModuleID=b.Module 的数据