Yesterday One of my friend give me to solve one interesting query. There are some specific forms list in one table. There is one more table for month. The status of form as per month recorded in another table. Base on status table, we have to find for which month status record not fill up for forms.
Table Name Field Name
Forms form_id
form_name
Months Month_id
Month_Name
Status form_id
month_id
status (whether filled or not)
comment (Comment for each entry)
Sample Data As per Bellow:
Table Name Field Name
Forms form_id
form_name
Months Month_id
Month_Name
Status form_id
month_id
status (whether filled or not)
comment (Comment for each entry)
Sample Data As per Bellow:
Required Result
I found one solution for this. The code of query as per bellow.
