I have three tables. Table A, Table B and Table C. These tables contain a date column and an Integer column. I want to join all three columns by the date into a third table called Results. This table will have one date column and a column for tableA data, tableB data and tableC data. I attached a spreadsheet with a sample of the data. I need to know how to write the query to do this. In the result query I would like nulls to show as zeros. The zeros are now in red just for display.
also the resulting data set should only have one row for each date.
thank you. I have been pulling my hair out all day with this one :-(