Archive for January 14, 2010

Mysql Select within Select (sel into sel)

SELECT
clients.id,

(SELECT Count(clients_job.id)

FROM
clients_job

WHERE
clients_job.client_id =  clients.id   ) AS JobCounter

FROM 
clients

ORDER
BY EPONIMIA ASC