Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What type of SQL joins are supported by ELS-QB ActiveX component?

April 26, 2017ActiveX component els-qb joins sql supported type

0

Posted

What type of SQL joins are supported by ELS-QB ActiveX component?

1 Answer

0

Posted

In ELS-QB ActiveX component the joins may be interpreted as a segment in the FROM-clause of the SQL statement or sometimes in the WHERE-clause. In particular, it supports INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, as well as the Oracle (+) outer join notation in the WHERE-clause. This pretty much covers all existing database engine implementations.