I have a join query that joins a table of shipped dates, qtys, and model numbers with a table of possible ship dates. This is to create a null (later converted to a zero) for dates where none of these four model numbers shipped.
The problem is, I need a date and a zero, if a null, for each of the four model numbers. if there are shipments for one of the four model numbers, there will be an entry for that date and no nulls for the other three. Short of making four separate queries, one for each model, is there a good way to do this? Thanks.