Computing Average

[mistektips]

Hi,

There are 2 tables:
Table A (SecurityID, SecurityName)
Table B (SecurityID, Price, ClDate)

The query is to find the average price with Name=ABC Corp in year 2005

I wanted to know if this query would be right. If not, then why?

select avg(price) from B, A group by securityID having A.SecurityID=B.SecurityID and SecurityName='ABC Corp' and year(ClDate)=2005

 

[bborissov]

select A.*,
       avg(price)
from B
LEFT JOIN A ON A.SecurityID=B.SecurityID
WHERE A.SecurityName='ABC Corp' and year(A.ClDate)=2005
group by securityID

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.