2选择咨询商订单_三行代码

来自 : ask.sov5.cn/q/5cQjHGE... 发布时间：2021-03-25

excel

这是我的问题

 SELECT t1.fecha_salida, t1.agencia, t2.fecha_salida, t2.directaFROM (SELECT fecha_salida, COUNT(*) AS agencia  FROM ventas  WHERE ventas.eliminado = 0 AND ventas.cliente_id !=2 GROUP BY fecha_salida) AS t1,  (SELECT fecha_salida, COUNT(*) AS directa  FROM ventas WHERE ventas.eliminado = 0 AND ventas.cliente_id =2 GROUP BY fecha_salida) AS t2 GROUP BY t1.fecha_salida

我的桌子是:

|------ |Columna|Tipo|Nulo|Predeterminado |------ |//**venta_id**//|int(11)|No| |usuario_id|int(11)|No| |tour_id|int(11)|No| |cliente_id|int(11)|No| |vehiculo_id|int(11)|No| |cashflow_id|int(11)|No| |total_compra|int(6)|No| |total_pagado|int(6)|No| |total_iva|int(6)|No| |total_comision|int(11)|No| |a_pagar|int(11)|No| |fecha_venta|datetime|No| |fecha_salida|date|No| |concretada|tinyint(1)|No| |pasajeros|int(3)|No| |nombre|varchar(500)|Sí|NULL |direccion|varchar(500)|Sí|NULL |observaciones|varchar(500)|Sí|NULL |forma_pago|tinyint(2)|No| |eliminado|tinyint(1)|No|

你能帮助我吗

SELECT t1.fecha_salida, t1.agencia, t2.fecha_salida, t2.directa FROM (SELECT fecha_salida, COUNT(*) AS agencia FROM ventas WHERE ventas.eliminado =...2选择咨询商订单,三行代码2选择咨询商订单