Re: Still Having a Problem Counting a String Field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In news:%23CPgvZbVFHA.2560@xxxxxxxxxxxxxxxxxxxx,
JC Harris <fake@xxxxxxxxx> rambled:
> I did have a SQL instance running on my SBS so I used that to check
> the code and it ran fine, so the code is good. It did, however,
> return 418 records, so the problem MUST be in the JOIN type I am
> assuming (JOINing is an area where I have problems, as you may have
> noticed in previous posts). Before I takle this, is my base
> assumption correct? In the SQL code it is listed as an INNER JOIN
> twice, so should I switch the JOIN type to an OUTER JOIN?

You can try it, but usually OUTER joins produce more results than INNER
joins.

--

KB - MCNGP "silent thug" #26

Briscobar AT gmail DOT com

Sometimes, I feel that www.mcngp.com isn't treating me with the respect
I deserve.


.