Question

如何把foreach中的sql语句写成一个子查询放入上面的sql语句中

$sql = "select sd.user_id userId,u.test_code testCode,COUNT(u.test_code) testCodeCount,sd.user_name as userName,sd.real_name as realName ,sd.mobile_phone as mobilePhone from ".$ecs->table('users')." u inner join ".$ecs->table('share_data'). "sd on u.test_code=sd.test_code where 1=1 $where group by u.test_code limit ".($filter['page'] - 1)* $filter['page_size'].",".$filter['page_size'];
$res = $db->getAll($sql);
foreach($res as $k=>$uInfo){
$sql = "select count(oi.order_id) orderCount,sum(oi.money_paid) sumMoneyPaid from ".$ecs->table('order_info')." oi inner join ".$ecs->table('users')." u on u.user_id = oi.user_id where oi.order_status<>4 and order_status<>2 and pay_status<>0 and u .test_code='$uInfo[testCode]'$where2 and add_time>datetime";

Answer 1

select f1 from table1的结果集做为查询条件循环查询。如：set @a =select f1 from table1foreach (@a){select * from table2where f2=@a}

sql 语句是对数据库进行操作的一种语言。 结构化查询语言(Structured Query Language)简称SQL,结构化查询语言是一种数据库查询和程序设计语言,用于存取数据以及查询、更新和管理关系数据库系统。