You are viewing a plain text version of this content. The canonical link for it is here.

Posted to torque-user@db.apache.org by ThanhLe <th...@sangtao.net> on 2007/03/13 11:41:25 UTC

Convert sql to Torque execute

Hi all,

This is my sql sentence and how can I convert to Torque:

select ar.*, dh.HISTORY_COUNT
from DRR_ARCHIVE ar
LEFT JOIN
   (select AR_CODE, count(AR_CODE) as HISTORY_COUNT
    from DRR_DOWNLOAD_HISTORY
    group by AR_CODE
   ) dh
ON ar.AR_CODE = dh.AR_CODE
ORDER BY AR_CODE

Thanks.

Best regards,

Javanesevn


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org