aebstract Posted March 5, 2010 Share Posted March 5, 2010 SELECT ordnn_Users.userid, CAST(ordnn_Users.username as varchar), CAST(ordnn_Users.email as varchar), ordnn_UserPortals.CreatedDate FROM ordnn_Users LEFT JOIN ordnn_UserPortals ON ordnn_UserPortals.UserID = ordnn_Users.UserID This is my current query above. I'm wanting to join a table called ordnn_NTForums_Posts. I'm just needing to get a total of how many rows are in that table where userid = ordnn_users.userid Link to comment https://forums.phpfreaks.com/topic/194288-how-would-i-join-this/ Share on other sites More sharing options...
aebstract Posted March 5, 2010 Author Share Posted March 5, 2010 Got it to work with this: SELECT ordnn_Users.userid, CAST(ordnn_Users.username as varchar), CAST(ordnn_Users.email as varchar), ordnn_UserPortals.CreatedDate, COUNT(ordnn_NTForums_Posts.UserID) AS postcount FROM ordnn_Users LEFT JOIN ordnn_UserPortals ON ordnn_UserPortals.UserID = ordnn_Users.UserID LEFT JOIN ordnn_NTForums_Posts ON ordnn_NTForums_Posts.UserID = ordnn_Users.UserID GROUP BY ordnn_Users.UserID, ordnn_Users.Username, ordnn_Users.email, ordnn_UserPortals.CreatedDate, ordnn_NTForums_Posts.UserID Link to comment https://forums.phpfreaks.com/topic/194288-how-would-i-join-this/#findComment-1022106 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.