KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Note: QUERY BY FORMULA use SQL Join
PRODUCT: 4D | VERSION: 20 | PLATFORM: Mac & Win
Published On: November 28, 2023


With the introduction of the "QUERY BY FORMULA use SQL Join" property in databases since version 11, this document aims to guide users on how to activate this feature without compromising the integrity of converted code. The document provides step-by-step instructions to safely enable the property and explores the potential benefits it offers. Readers will gain insights into optimizing their database queries by harnessing the power of SQL Join through this newly introduced functionality. The guide emphasizes risk-free implementation and highlights strategies for maximizing the efficiency of converted databases while utilizing the advanced features introduced in the latest version.

Download Complete Tech Note: Tech Note Document