/dev-club/b/dev-blog/posts/sugarbean-best-practices-for-working-with-related-recordsThis blog by SugarCRM Technical Account Manager and Solution Architect Angel Magana is reposted with his permission. See Angel&#39;s Blog: SugarCRM: Related Data Interactions for the original post from Angel&#39;s blog. In this post, ...en-USTelligent Community 12https://sugarclub.sugarcrm.com/dev-club/b/dev-blog/posts/sugarbean-best-practices-for-working-with-related-recordsFri, 10 Aug 2018 02:16:27 GMT5c521d64-519d-47a6-9065-134618b211bf:32cba506-82d0-4721-8886-300f3edf76a8Rahul Gupta0 <p>How to get result of multiple bean join with where clause.</p><p>I mean please suggest me best way for&nbsp; SQL RAW query convert into SugarBean.</p><p>I want to convert my multiple table join query into sugarbean/sugarQuery.</p><p>Thanks Rahul&nbsp;</p> <img src="https://sugarclub.sugarcrm.com/aggbug?PostID=863&AppID=56&AppType=Weblog&ContentType=0" width="1" height="1">