Help with simple listing query

[sbantz]

SugarCRM 5.0.0b with Zucker reports 1.8

I am trying to run a simple listing query that shows the date a note was entered, who it was created by, and the name of the note. The problem I am having is that I cannot figure out how to have the query show the username rather than the alphanumeric identifier for the user, like 3b388195-355d-827c-d111-46eee823b0bc

SELECT notes.date_entered, notes.created_by, notes.name
FROM notes
ORDER BY notes.created_by, notes.date_entered;

I assume I need to have this show user.username but I cannot figure out how to get it to show that correctly.

Thanks for any pointers.

[Angel]

Try this:

SELECT notes.date_entered, concat(users.first_name, ' ', users.last_name), notes.name
FROM notes
JOIN users
ON notes.created_by = users.id
ORDER BY notes.created_by, notes.date_entered;

[sbantz]

That's why I like these forums a lot. Thank you very much, Angel. it worked like a charm.