Ann writes "Ok, I wanted to test my SELECT stmt in SQL Query Analyzer before I put it in prodcution. I place a select stmt to compare the acctnum in one table with the acctnum in another table, but not all of the records come up. I did check the ones that didnt come up from the first file and they were in the second file but it didn't show up.
Is there something I am missing. Here is the code I am using:
select dbo.scrub_return.acctnum, dbo.scrub_return.found, dbo.bi_prescrub.acctnum from dbo.scrub_return, dbo.bi_prescrub where dbo.scrub_return.acctnum = dbo.bi_prescrub.acctnum and found=' '"