Yo le hago asi:
Código PHP:
$SQL ="SELECT col.nombre as COLONIA, calle.nombre as CALLE, Servicio.servicio, SUM(OD.importeunitario) AS Venta";
$SQL .= " FROM Ordendetalles OD, Orden O, Clientes C, ncolonias Col, ncalles Calle, Sucursales S, Servicio";
$SQL .= " WHERE OD.ordenid=O.ordenid AND O.clientesid=C.clienteid AND";
$SQL .= " Servicio.servicioid=O.servicio AND";
$SQL .= " SUBSTRING(C.Clienteid FROM 1 FOR 1)=S.sucursalid AND";
$SQL .= " Col.colid=C.xcolonia AND Calle.calleid=C.xcalle AND";
$SQL .= " OD.status=1 AND O.status < 7 ";
$SQL .= " AND O.horainicio BETWEEN '$FechaIni $AM' AND '$FechaFin $PM'";