https://sqlines.com/ 2026-04-18T11:47:13+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2022-10-16T16:23:55+00:00 https://sqlines.com/informix-to-mariadb/outer?rev=1665937435&do=diff Informix supports the specific OUTER clause in the FROM clause of the SELECT statement to define the outer joins. It has to be converted to ANSI SQL outer join syntax in MariaDB. Consider the following tables with sample data: CREATE TABLE cities (name VARCHAR(30), country VARCHAR(30)); CREATE TABLE countries (name VARCHAR(30), capital VARCHAR(30), region VARCHAR(30)); CREATE TABLE regions (name VARCHAR(30), continent VARCHAR(30)); -- Cities INSERT INTO cities VALUES ('Malaga',…