here is the SQLquery am trying to write in QTP
select GL_TRANSACT_DTL.ref_num,GL_TRANSACT_DTL.DEBIT_ACCT _NUM,GL_TRANSACT_DTL.CREDIT_ACCT_NUM,GL_TRANSACT_D TL.CURR_AMT
FROM GL_TRANSACT_DTL, gl_journal
WHERE GL_TRANSACT_DTL.gl_journal_id = gl_journal.gl_journal_id
Order by 1,2
if I did it as above it doesn't work there is error in couting the Where statement
I spent 4 hours and couldn't write it the right way
the problem solved , it was one space missing on this below lines
" FROM GL_TRANSACT_DTL, gl_journal " &_ 'one space before "
"WHERE GL_TRANSACT_DTL.gl_journal_id = gl_journal.gl_journal_id " &_ 'one space required before "