Query within a query

TenKracer · #1 (**permalink**) 10-21-03, 17:38

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,

dbmadcap · #2 (**permalink**) 10-22-03, 15:46

Can you explain what you want to achieve?

Did you try this? Does this sql work?

Code:

SELECT Nature.Nature, t.Apr
FROM Nature, 
  (SELECT NatureCountPerMonth.ComplaintNumber AS Apr,
               NatureCountPerMonth.Nature 
    FROM NatureCountPerMonth WHERE Month = 4) t
where Nature.Nature = t.Nature;

TenKracer · #3 (**permalink**) 10-22-03, 17:11

Cheers,
That would be it... I figured you would change the name of a table the same way you change a field. This is what I needed.

Thanks,

Internet Services

Web Development

Digital Marketing

Consumer Tech