Hello,
I have a question regarding SQL. Please refer my attachment below:
This view of table give me correct of the output. Which give me 36 of results. Please refer attachment below:
But, when i try to put additional table which i need to indicated whether the form is completed or draft, it's because i do not want to show "draft" form in the table.
Have a look on the table below:
After i added this table into my view, the output is repeated 2 times and give me 72 of results.