>This select statment
>

>select sites.permid as permid, sites.site_name, sites.startdate, sites.enddate, ;
>	pei.*, GetERInitials(sites.er) as ER,  ;
>	h.surveys_distributed ;
>	from newbluebook!sites ;
>	left outer join new_pe_pei_database!PEI ;
>		on sites.permid=pei.permid ;
>	left outer join newsurveys!history h;
>		on sites.permid=h.permid ;
>	where ! isblank(startdate) and isblank(enddate) and ;
>	pei._year = lnYear and ;
>	h._year = lnYear-1 ;
>	order by sites.er, site_name ;
>	into cursor crsReport	
>

>misses records where there is no matching history record. I thought the outer join would include ALL of the qualified sites records but this is apparently not the case. What do I have wrong?

In addition to my reply please see Re: Understanding LEFT JOIN Thread #1042886 Message #1042888 and the whole thread.