如下：一张订单表多个字段关联用户表：

1.链表查询

SELECT cu.id AS 'id',cu.version AS 'version',cu.cid AS 'cid',cu.uid AS 'uid',cu.shopName AS 'shopName',cu.address AS 'address',
cu.totalPrice AS 'totalPrice',cu.orderType AS 'orderType',
cu.state AS 'state',cu.cCreateTime AS 'cCreateTime',cu.decorate AS 'decorate',cu.area AS 'area',cu.roomArea AS 'roomArea',
cu.machinePrice AS 'machinePrice',cu.caid AS 'caid',
cu.cooperationtypeid AS 'cooperationtypeid',cu.cooperationRebate AS 'cooperationRebate',cu.cooperationPrcie AS 'cooperationPrcie',
cu.machineDiscount AS 'machineDiscount',cu.alreadyPaid AS 'alreadyPaid',cu.updateTime AS 'updateTime',cu.cooperationdeposit AS 'cooperationdeposit',
cu.updateUserid AS 'updateUserid',cu.overseerId AS 'overseerId',cu.decorationQuotation AS 'decorationQuotation',cu.machineDeposit AS 'machineDeposit',
us1.uName AS 'serviceuName',us2.uName AS 'updateName'
FROM `customerorder` AS cu LEFT JOIN `userdetail` AS us1 ON us1.id=cu.uid LEFT JOIN `userdetail` AS us2 ON us2.id=cu.updateUserid

2.子查询
SELECT cu.id AS 'id',cu.version AS 'version',cu.cid AS 'cid',cu.uid AS 'uid',cu.shopName AS 'shopName',cu.address AS 'address',
cu.totalPrice AS 'totalPrice',cu.orderType AS 'orderType',
cu.state AS 'state',cu.cCreateTime AS 'cCreateTime',cu.decorate AS 'decorate',cu.area AS 'area',cu.roomArea AS 'roomArea',
cu.machinePrice AS 'machinePrice',cu.caid AS 'caid',
cu.cooperationtypeid AS 'cooperationtypeid',cu.cooperationRebate AS 'cooperationRebate',cu.cooperationPrcie AS 'cooperationPrcie',
cu.machineDiscount AS 'machineDiscount',cu.alreadyPaid AS 'alreadyPaid',cu.updateTime AS 'updateTime',cu.cooperationdeposit AS 'cooperationdeposit',
cu.updateUserid AS 'updateUserid',cu.overseerId AS 'overseerId',cu.decorationQuotation AS 'decorationQuotation',cu.machineDeposit AS 'machineDeposit',
(SELECT uName FROM `userdetail` WHERE id=cu.uid) AS 'serviceuName',(SELECT uName FROM `userdetail` WHERE id=cu.updateUserid) AS 'updateName'
FROM `customerorder` AS cu

总结：

1，表关联的效率要高于子查询，因为子查询走的是笛卡尔积
2，表关联可能有多条记录，子查询只有一条记录，如果需要唯一的列，最好走子查询

最新文章

  1. Indy FTP 警告：Only one TIdAntiFreeze can be active in an application
  2. 【已解决】新搭建的VPN服务器客户端无法正常连接
  3. 有关sublime text的插件安装
  4. 基于任务的异步模式(TAP)
  5. Hadoop阅读笔记（六）——洞悉Hadoop序列化机制Writable
  6. apache端口的修改
  7. 10分钟制作UWP汉堡菜单
  8. Js脚本选取iframe中的元素
  9. 基于CentOS与VmwareStation10搭建Oracle11G RAC 64集群环境：4.安装Oracle RAC FAQ-4.3.Oracle 集群节点间连通失败
  10. [WCF]IIS部署到新系统
  11. thread dump
  12. semaphore实现浏览器的读写原理
  13. adb shell 命令详解,android
  14. ctx中的body无法找到
  15. 详解Nginx服务器配置
  16. OpenStack-Neutron-VPNaaS-配置
  17. 萌新接触前端的第三课——JavaScript
  18. Unity3D工程版本管理方案【转自 兜里】
  19. border-radius背景色超出圆角问题解决
  20. java编译器

热门文章

  1. [APIO 2009] Atm
  2. Linux查看实时网卡流量的几种方式
  3. 【算法】php计算数字k在一段数字范围出现的次数
  4. kafaka quickstart
  5. C/C++ 动态存储分配 malloc calloc realloc函数的用法与区别
  6. Vue+Django2.0 restframework打造前后端分离的生鲜电商项目（3）
  7. 神经网络中w,b参数的作用（为何需要偏置b的解释）
  8. numpy的使用方法
  9. io系列之其他事项
  10. 开发问题及解决--java.lang.IllegalStateException: Circular dependencies cannot exist in RelativeLayout