Skip to Content
0
Former Member
May 30, 2012 at 09:49 PM

Need all records whether a match or not with joined table

1679 Views

I have a report that joins an order table with the customer table. I want to select all customers whether they have orders or not. It is grouped by route and I want to show routes whether there are orders or not. I can't seem to get the join to work to where it pull all the data I need.