Join 2 tables

Is there any way to join two tables like we join in MySQL like inner join , outer join etc
I want data from 2 tables on foreign key basis

Parents

0 Enrico Simonetti over 5 years ago
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)
--

Enrico Simonetti

Sugar veteran (from 2007)

www.naonis.tech

Feel free to reach out for consulting regarding:

API Integration and Automation Services

Sugar Architecture

Sugar Performance Optimisation

Sugar Consulting, Best Practices and Technical Training

AWS and Sugar Technical Help

CTO-as-a-service

Solutions-as-a-service

and more!

All active SugarCRM certifications

Actively working remotely with customers based in APAC and in the United States
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rana Awais over 5 years ago in reply to Enrico Simonetti

from where i download sugarQuery?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rana Awais over 5 years ago in reply to Rana Awais

Enrico Simonetti??
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rana Awais over 5 years ago in reply to Rana Awais

i have posted the example in above message
please tell me how i can intergrate it with sugarQuery and from where i can download that sugarQuery.php

Enrico Simonetti
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Rana Awais over 5 years ago in reply to Rana Awais

i have posted the example in above message
please tell me how i can intergrate it with sugarQuery and from where i can download that sugarQuery.php

Enrico Simonetti
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data