I have this code:
SELECT nDebit1.*, companyid.bankname AS bank, companyid.companyid AS newid ;
FROM FORCE nDebit1 LEFT JOIN companyid ;
ON ALLTRIM(nDebit1.companyid) == ALLTRIM(companyid.companyid) ;
ORDER BY nDebit1.bankname, nDebit1.settdate, nDebit1.mid, ;
nDebit1.amount, nDebit1.orgtracnum, nDebit1.dbaname, nDebit1.reasoncode, ;
nDebit1.orgtracnum, nDebit1.cleared ;
INTO TABLE ndebit2
works okay most of the time. Every now anthen it leaves out a few records. I read in the HAckers Guide that you should use GROUP BY when you have a calculation of some type in the Select statement. Does that apply when you are joining two tables?
Thanks in advance for your help! :-)
Randall L. Johnson