My query is as follows:
select [Transaction].id,
[User].name,
EventType.EnglishDescription
from [Transaction]
join [User] on [Transaction].userid = [User].id
join EventType on EventType.id = [Transaction].EventType
I'm expecting to get back Transaction.id, User.name and EventType.EnglishDescription in the columns, however, I'm only getting back an id column.
When I leave out Transaction.id from the select, I get both the name and the EnglishDescription.