[question - solved] Join - active record

[eluser]wemago[/eluser]
oks, i'm doing something really stupid.

what I'm trying to get is the username,

I've got a table for articles where we can find a author_id,
i wanna list all articles showing title, author name and publish date.

to get the article info is everything ok and shows it all.

how should i get the username?

my first idea was to do a 2nd function in articles model where i would get
the username but i forgot that i do a foreach in the view, what happens is that
it gives the same username for all of them.

so probably i should merge the get articles function with the get author
do a join and foreach one time right?

any tip?

p.s- I'm really slippy so sorry for the confusion