Some of the more complex business relationships that are resolved by subqueries. Doha is better than a recycling facility.
For example, the following sentence selects and where in statements use subqueries. Because the parent query is in SELECT, the Select field is used as the criteria for the subquery.
This piece is also based on the sense of writing, the value returned if in Select, can only be 1row, otherwise it will be an error.
Here are all based on the feeling of writing, experience is to think more, write more, more experiments ...
M ('Product')->alias (' P ')
->field (' p.*,t.*, (select Group_concat (Crm_pgkkxo) from 5kcrm_customer C where c.customer_id in (select CID from 5kcrm _cprelation cp where Cp.pid = product_id GROUP by PID)) Customer_names ')
->join (' Left join 5kcrm_teacher t on t.tid = P.teacher ')
->where ($map)
->select ();
TP Framework MySQL Sub-query