如何知道字段属于那个表？

Question

我有表A

ID	Title	Content
1	ttttt	ccccc
2	ttttt	cccc

表B

ID	name
1	nnnn
2	nnnn

当我 查询出来两个表的内容时 如 select A.*,B.* from A,B

得到数据

ID	Title	Content	ID	Name
1	ttttt	ccccc	1	nnnn
2	ttttt	cccc	2	nnnn

 

我如何知道 后面的ID和name字段是表B的？

Answer 1

select a.id as 表a的id,a.title as 表a的title,b.id as 表b的id,b.name as 表b的name from a,b

  

---

啥叫乐观－得瑟的最高境界

Answer 2

这个要更改sql语句 DataRader 或者Command Connection中有方式获取么？

Answer 3

没有……数据库返回的列就那么多

---

---

The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
Visual C++ MVP