Re: Group by: Not getting expected output

In article <1147262616.739625.213680_at_y43g2000cwc.googlegroups.com>, Carlos says...
> >>How to alter/design query for the same?
>
> Try OUTER JOIN with NVL.
>

The query as posted by Sameer:

SELECT tcode,
  COUNT(*) AS GradeEq2to3
FROM info
WHERE tavg >= 2
 AND tavg < 3
GROUP BY tcode
ORDER BY tcode;

selects from only one table - where COULD an outer join be placed?

> HTH
>

I doubt very much it does.

-- 

jeremy