如下:一张订单表多个字段关联用户表:
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&#