Join 2 tables

SugarQuery offers handy wrappers to join across module, using the "link fields" to automatically relate two modules's SQL tables. You can read more about it here: https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.1/Data_Framework/Database/SugarQuery/#Relationships

Restrain yourself from using direct SQL queries. While they might be "quicker" to put together (if you are not familiar with SugarQuery), it opens your solution up to problems (eg: SQL injection, portability across databases, missing a relevant parameter on the query to name a few)

from where i download sugarQuery?

from where i download sugarQuery?

Enrico Simonetti??

Rana Awais, your original question was about joining MySQL tables, so that's why I pointed you towards SugarQuery. Based on the question, I thought you wanted to build a custom api or functionality.

SugarQuery is included on Sugar's codebase.

There are many ways to achieve what you want to do. One example can be found here: https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.1/Cookbook/Web_Services/REST_API/PHP/How_to_Fetch_Related_Records/

You could also bulk apis together so that you limit the number of http requests you make.

If you open your instance's /rest/v10/help url, you will get a help page on how to use our api as well.