多表查询

Question

C# 中在两个表中查找符合条件的记录的条数的SQL语句

Answer 1

select count(*) from 表1, 表2 where 条件

Answer 2

select * from a,b lefe jon on a.* =b.* where.....

Answer 3

select * from a inner join b on a.xx=b.xx where a.xx=  and  b.xx= order by a.xx

---

Love SQL