Qurey to link with target date

[prabhus]

Hi,

need your help to fix this.

I have to make a query using the following case, I have two tables, in the first table i have the materials and its received date and in my second table i have the month the target date for every month to receive the material. Now linking this two tables, i want to see the from the first table on every month hom many materails i received after the target date how to do this.

Table 1
Field1 Date
Field2 Month
Field3 Material
Field4 received_date

Table 2
Field1 Month
Field2 Target_date

 

[CJ_London]

I'm struggling to understand what you want. Perhaps you can provide some sample data and what result you want for that sample data. Also is there any relationship between table1 and table2?