I have 2 tables:
- Table A has a complete list of quarter hour intervals for a 24 hour day. Table B has a store with it's average ticket count in quarter hour intervals.
My problem is that there are missing intervals in table B. I would like to use table A to find all nulls or missing intervals in table B.
Is there a method? I tried a left join from the only column in Table A to B but the SQL won't show the nulls in Table B.