select A.name,b.content, from A表,B表 where A表.ID=B表.ID --表名和字段名之间用.
select A.name,b.content, from A表,B表 where A表.ID=B表.ID --表名和字段名之间用.
cmd.CommandText = "select A.name,b.content from A表 A,B表 B where A.ID=B.ID";
cmd.CommandText = "select A.name,b.content, from A表,B表 where A表ID=B表ID"; --------------------------------- cmd.CommandText = "select A.name,b.content from A表,B表 where A表ID=B表ID"; 多了个逗号
select A.name,b.content, from A表,B表 where A表.ID=B表.ID --表名和字段名之间用.
select A.name,b.content, from A表,B表 where A表.ID=B表.ID --表名和字段名之间用.
---------------------------------
cmd.CommandText = "select A.name,b.content from A表,B表 where A表ID=B表ID";
多了个逗号