Hello

Could you help me how to write mysql query to join two tables?

Currently I have this query:

SELECT actor, title, content, created FROM #_community_activities WHERE created > "2012-12-13 12:00:00" AND (app != "com_easyblog") LIMIT 1000

"actor" field shows Joomla user ID, so it's the same like "id" field in "#_users" table

I would like to join "username" field from Joomla "#_users" table into my query, so that ARI output shows this:

username actor title content created

Regards

Hello,

Use the following query:


SELECT
U.username,
A.actor,
A.title,
A.content,
A.created
FROM
#__community_activities A INNER JOIN #__users U
ON A.actor = U.id
WHERE
A.created > "2012-12-13 12:00:00"
AND
A.app != "com_easyblog"
LIMIT 1000


Regards,
ARI Soft

Hi

Thanks, it works
I'll use this example to re-modify all my other ARI queries.

Regards

I've tried the above but U.name doesn't appear in the resulting table (all the others do)
user_id is the same as the user table id - any ideas why?

SELECT
U.name,
A.course_id,
A.lpath_id,
A.user_id,
A.user_status,
A.start_time
FROM
#__lms_learn_path_results A INNER JOIN #__users U
ON A.user_id = U.id

Hello,

Could you provide a link to a page where we can see the problem and a temporary access to your J! backend by email so we can investigate it?

Regards,
ARI Soft

Try now. The column was hidden because "Columns settings -> Hidden" parameter was set to "Yes" for the first column.

Regards,
ARI Soft