You may use UNION here:

SELECT hst.order_date, bsn.store_name, hst.total, hst.earned ;
	FROM history AS hst, business AS bsn;
	WHERE bsn.vchr_code==hst.vchr_code .AND. ;
		BETWEEN(hst.order_date,{^2001-09-01},{^2002-08-31}) ;
UNION;
SELECT {}, bsn.store_name, 00000.00, 000000.00 ;
	FROM business bsn;
	WHERE bsn.vchr_code not in ;
            (sele vchr_code from  history);
ORDER BY 2,1 ;
INTO TABLE ecrtemp

Field types and lengths must be the same in both union statements (correct 00000.00 above as needed), and the order must be by field number in select.

>Here's an SQL SELECT that I'v cobbled together that gave me the results I was looking for:
>

SELECT hst.order_date, bsn.store_name, hst.total, hst.earned ;
>	FROM history AS hst, business AS bsn;
>	WHERE bsn.vchr_code==hst.vchr_code .AND. ;
>		BETWEEN(hst.order_date,{^2001-09-01},{^2002-08-31}) ;
>	ORDER BY bsn.store_name, hst.order_date ;
>	INTO TABLE ecrtemp.DBF

>Now, how do I get it to add a 'blank' row (a name but no date-total-earned) for records in the business table that do not have any matching data in history?