Saturday, December 28, 2013

Join statement

Try the below:(Not tested)



select stp.scpShortName, max(stc.scClosePrice)
from Stockcompany stp
Left Join StockClosing stc
on stp.scpTickerSymbol=Stc.scTickerSymbol


Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)