Hi, I am having some logic trouble... I think I want to create a Left Join but I am not sure here is my query...
SELECT Nature.Nature, t.Apr
FROM Nature LEFT JOIN (SELECT NatureCountPerMonth.ComplaintNumber AS Apr, NatureCountPerMonth.Nature FROM NatureCountPerMonth WHERE Month = 4 AS t) ON Nature.Nature = t.Nature
But it doesn't work. How do I nest queries within queries? Is it a syntax problem or is this something that can't be done?
Thanks in advance for any help,