Just to be more specific, I have four tables.  The group by function will not work since I am not using an aggregate function.  Each customer only exists once so...