A表中的B字段是C表的关联字段,D是C表中需要查询的字段
关联查询:select d.c from a left jion c on a.b=c.b
in的用法:select * from table1 a where a.col in ('值一','值二','值三')
A表中的B字段是C表的关联字段,D是C表中需要查询的字段
关联查询:select d.c from a left jion c on a.b=c.b
in的用法:select * from table1 a where a.col in ('值一','值二','值三')