SQL 怎样查询两张表所有相同的字段?

查两张表的信息：select * from A,C where A.id=c.id 只查A表的信息：select * from A where exists (select 1 from C where A.id=C.id)