What is the Difference Between Left Joins and Inner Joins in SalesLogix?

Question:

What is the difference between Left joins and Inner joins in SalesLogix?

Answer:

Inner
and left denotes the type of joins between tables.  If you have an inner
join then a record must exist in both tables in order for results to be
returned.  If it is a left join then all rows from the parent table will
be returned even if there is not a matching record in the other table.

 

Select
Account inner join accountsummary on account.accountid=accountsummary.accountid

returns
only records where a matching Accountid record exists in both the account and
account summary table

 

Select
Account left join accountsummary on account.accountid=accountsummary.accountid

returns all account records even if the
accountsummary table does not have a matching accountid in it.

 

Submit a Comment

Your email address will not be published.

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!