Does Maria DB support ANSI-89 join syntax

Question

Does Maria DB support ansi-89 join syntax?

SELECT sites.site_id, sites.site_name, pages.page_id, pages.page_title
    FROM sites, pages
    WHERE sites.site_id = pages.site_id;

or only ansi-92 syntax?

SELECT sites.site_id, sites.site_name, pages.page_id, pages.page_title
FROM sites 
INNER JOIN pages
ON sites.site_id = pages.site_id;

Answer 1

Short answer - yes, both options are supported.