Select a 3 tabblas

[julia2021]

Amigos ya los resolví:

SELECT tbl_clientes.id_cliente, tbl_clientes.nombre,
tbl_contratos.id_contrato, tbl_contratos.nombre,
tbl_ordenes.id_orden, tbl_ordenes.titulo, COUNT(*) As total

FROM tbl_ordenes INNER JOIN tbl_contratos
ON tbl_ordenes.id_contrato = tbl_contratos.id_contrato

INNER JOIN tbl_clientes
ON tbl_clientes.id_cliente = tbl_contratos.id_cliente

GROUP BY `tbl_clientes`.`id_cliente`
ORDER BY `total` DESC