I have a basic query with 2 tables.
Name | Description
Name | Date | Quantity
I need a list of all descriptions in Table A with a Total Quantity from Table B
What I get is a list of all records from Table A that have activity in Table B, but I need to see ALL records in Table A and just assign a 0 to the ones that don't have anything in table B.
I have a right join on Name, so that's not the issue, any ideas how I can get all records from Table A?