Customer List Script

<report name="Customer Quick Report Test" autoRun="true">

<query addWhere="true">


select 
	   A.CUSTNAME
	,  A.ADDRESS1
	,  A.City
	,  A.SLPRSNID
	,  A.STATE
	,  A.ZIP
	,  A.PHONE1
	,  C.Email_To
	,  C.Email_CC
	,  C.Note

        from RM00101 as A
	Join spvCustomer as C
        on A.CUSTNMBR = C.Customer_Num 

/*where*/

</query>
</report>

Leave a Reply