Home Forums Article Discussions Article Discussions by Author Discuss content posted by Brian Ellul Sub query expressions vs. Joins. RE: Sub query expressions vs. Joins.
bayudw
SSC Journeyman
Points: 84
More actions
July 22, 2010 at 4:17 am
#1196725
Thanks for your replay.
I use this query below :
Select A.AccountID, A.OpenDate,
'Amount'=(Select Top 1 TransactionAmount From Transaction Where AccountID=A.AccountID order by TransactionDate desc)
From Account A
or
any idea else ?