HSQL query = select InvTxn.ivStr2,
InvTxn.ivAttdtls,
trunc(current_date()-InvTxn.ivDuedate),
InvTxn.cstHdr.csName,
InvTxn.comp_id.ivId,
InvTxn.comp_id.ivDate,
InvTxn.ivDuedate,
InvTxn.ivTlamt,
InvTxn.accrTxn.arOutamt,
InvTxn.cstHdr.csPayr,
CmtsLog.cmAction,
CmtsLog.cmText,
InvTxn.ivCurr,
StsLog.stsHdr.stName,
InvTxn.cstHdr.csId
from InvTxn as InvTxn
LEFT JOIN InvTxn.stsLogs as StsLog
LEFT JOIN InvTxn.cmtsLogs as CmtsLog
where
InvTxn.enttyHdr.enId IN (4)
and InvTxn.ivClosed = 0
order by
InvTxn.cstHdr.csId,
InvTxn.ivDuedate
hi actually have specified 2 tables but here giving an alias name.............right...........