db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ThanhLe <than...@sangtao.net>
Subject Convert sql to Torque execute
Date Tue, 13 Mar 2007 10:41:25 GMT
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


Mime
View raw message