Hi Sajid,
Please provide the output of EXPLAIN for the query (and enclose the output in [ code] [/ code] tags)
For future reference, here's the query in a more readable format:
SELECT tbltransactionac.eDate AS eDate, tbltransactionac.DocNo AS DocNo,
tbltransactionac.Type AS Type, tbltransactionac.PayDesc AS PayDesc,
ifnull(tbltransactionac.Debit,0) AS Debit,
ifnull(tbltransactionac.Credit,0) AS Credit, tblaccounts.ID AS ID,
tblaccounts.AcTitle AS AcTitle, tblaccounts.Type AS accType,
tblaccounts.Address AS Address, tblaccounts.City AS City,
tbltransactionac.ID AS tid
FROM (tblaccounts JOIN tbltransactionac
((ON tblaccounts.ID = tbltransactionac.AccID)))
ORDER BY tbltransactionac.eDate;
Hope this helps,
Jørgen Løland
Software Engineer, MySQL, Oracle
jorgenloland.blogspot.com