连表查询
我们来过
记录自己学习android和后台开发的过程,最为以后的只是参考
展开
-
SQL 语言整理 ——mysql
测试sql语句的性能select **BENCHMARK**(**100000**,**"**select *,**DATE**(pre_start_date) as times from jcb_tnonstandardproduct as tp INNER JOIN jcb_t_product on pTrustId = tp.product_id**")** BENCHMARK();测试SQ原创 2015-09-01 22:39:12 · 472 阅读 · 0 评论 -
sql 链表查询语句
SELECT *FROM jcb_t_asset_combo_item AS jtaci**INNER join** (select pType,pId,(**CASE WHEN ISNULL(pTrustId)** THEN pFundId ELSE pTrustId END) AS choiceId FROM jcb_t_product) AS product ON prod原创 2015-09-03 16:49:42 · 6176 阅读 · 0 评论