Re: JOIN vs WHERE; Why can't I get the same results?

Right off, I see you skipped entint in the FROM of the first query. Try adding that in and see if the results change. Thanks Ted. That was it. I stared at that thing all afternoon yesterday and I just couldn't see it. I hate when that happens. Thanks again. Ken www.stic-cil.org

JOIN vs WHERE; Why can't I get the same results?

Hi folks, Given tables: Donents entid entname 12 Jeanne Blow 29 Karen Keith Johnson Entmems entidpeoid peotype memstatus 12 12358 PC (Jeanne) 2912127 P C (Karen) 29441P C

Re: JOIN vs WHERE; Why can't I get the same results?

Right off, I see you skipped entint in the FROM of the first query. Try adding that in and see if the results change. -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: