Better to see once than to hear a hundred times. This small article explains what are the different kinds of joins in SQL.
At the first time you should take into account that SQL is a declarative 4th generation language. So the best way to use it (especially for beginners) is to write the query and let SQL optimizer do its job. That means thinking in set-oriented terms and avoiding sub-queries.
Let's take two example tables: Companies and Contacts.
Since early XE versions C++ Builder supports Delphi units directly added in C++ project and compiles them as well as C/C++ source. However, this approach has several drawbacks:
Delphi 32-bit native code optimizing compiler (dcc32) for Windows, including high performance x86
Assembler
Delphi toolchains for Windows
Regardless indicated options dcc32 doesn't work in Delphi Berlin Starter with the error message "This version of the product does not support command line compiling".
Recent comments