i found left join queries are taking more time for execution compared
with MsAccess. i am sure that i have given proper indexes. there is no
problem with the inner join queries.

Sathiesh