Create databases where you need them.
DBLX supports most of the database join types, such as JOIN, INNER JOIN, and OUTER JOIN.
When the JOIN keyword is used, it is treated the same as an INNER JOIN.
LEFT JOIN is treated the same as LEFT OUTER JOIN, and RIGHT JOIN is treated the same as RIGHT OUTER JOIN.
DBLX supports all joins using only one join syntax in each SQL statement. Joins may be composed of the following types of syntax:
The SQL 'FULL JOIN' syntax and the UNION syntax are not supported in this release of DBLX.