MySQL JOIN

[eluser]IamPrototype[/eluser]
If I need to display data from users and userprofiles it works like a normal query, right?

Code:

// Mysql JOIN Query
// ...
foreach($query as $row)
{
echo $row->uid . '<br />; // from users
echo $row->website; // from userprofiles
}