Join statement

Try

select Comp.scpShortName, MP.MaxPrice

from StockCompany Comp 
LEFT JOIN (select TickerSymbol, max(scClosePrice) as MaxPrice

from StockClosing GROUP BY TickerSymbol) MP ON Comp.TickerSymbol = MP.TickerSymbol

---

For every expert, there is an equal and opposite expert. - Becker's Law





My blog



My TechNet articles