[fw-general] Question about table querying

[José de Menezes Soares Neto]

Friends,

I have two tables:

Users ( Id, Name, Type_Id, Username, Password )

Types ( Id, TypeName )

And Type_Id refereer to field Id from table Users.

My query for retrieve information is

$users = new Users();
$users = $users->fetchAll(" Name LIKE '$query' ");
$users = $users->toArray();

But I need to show all fields from Users but with TypeName instead of
Type_Id.

What can I do?

Best Regards,

José