SQL 语句联合查询急，在线等，解决即结贴！select * from table1where ldate2012-6-26 and number(select
SQL 语句联合查询 急，在线等，解决即结贴！
select * from table1 where ldate='2012-6-26' and number=(select number号 from table2 where company='aa')
我想按条件查询table1 ，使得table1 中的字段满足后边的查询语句，应该怎么写？
[解决办法]
- SQL code
select * from table1 where ldate='2012-6-26' and number in (select number号 from table2 where company='aa')