connect to table

i create a message list with cc
like this
message table is = _d_msg

id|title|intro|realeted|user_id|date|

i can get user name its easy ok but i wanna show user_name and email
user table is

tabelname=_d_user
user_id|name|surname|pass|email|


in cc its easy to show table _d_msg but how can i get user_name and email from _d_user table and
the message list will be


id|title|intro|realted|name|email|

Hi Kurt,

This is quite difficult at present as you really need the ChronoConectivity query to include a join.

Have you tried calling the Joomla User object in the body section with $user = JFactory::getUser($user_id); ?? That might work.

Bob