SQL Join Statement Issue
Posted
by coffeeaddict
on Stack Overflow
See other posts from Stack Overflow
or by coffeeaddict
Published on 2010-04-01T13:48:01Z
Indexed on
2010/04/01
13:53 UTC
Read the original article
Hit count: 132
tsql
I'm tring to grab all fields from the latest Cash record, and then all fields from the related TransactionInfo record. I can't quite get this to work yet:
select t.*, top 1 c.* from Cash c
inner join TransactionInfo t
on c.TransactionID = t.id
order by createdOn desc
© Stack Overflow or respective owner