Question

在asp.net中怎样用一个select语句查两个表的内容

Answer 1

将两张表做联接或者使用子查询就可以了
select * from A where A.id=(select id from B)
select * from A inner join B on A.id=B.id
on 后面表现两表关联的列

Answer 2

例如：表A 表B

1.假如A表与B表无任何关联
SELECT * FROM A CROSS JOIN B

2.假如A表的某个字段与B表的某个字段有关联
SELECT * FROM A INNER JOIN B ON A.字段名 = B.字段名

Answer 3

select * from table1
union
select * from table2

Answer 4

select a.*,b.id,b.name from tablea as a,tableb as b 如果有条件 where ...