I am having two tables
Table A location_index,Date ,location...etc
Table B: Location_Index,location_desc ...etc
There are some missing Records in the Location for particular dates in given month
so how to write the query to display the missing record as zero in the out put:
means if there is a record on that day for the location it should that value else should display zero. Data base is SQL Server.
Front end query desing using Crystal reports.
Thanks & Regards