I am having problem to write MySQL query to get data from 2 tables in the same database - one of them is Jomsocial table and the other is Joomla table) and hope to get some help from our friends here. First table jml_community_users userid points Second table jml_users userid name I like to get the name and points of each member since 01/01/2012. I was trying to use Straight Join but having problems and also have problem with the date as well. I appreciate for any help you can spare. Thanks a lot.
SELECT u.userid, cu.points FROM jml_users AS u LEFT JOIN jml_community_users AS cu ON u.userid = cu.userid WHERE DATE(u.registerDate) >= DATE('2012-01-01') Code (markup):