Convert sql to Torque execute

[ThanhLe]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]