One of the basic aims of Structured Query Language (“SQL”) is to provide a standard for interacting with databases. Unfortunately,
most SQL code requires at least some changes before being ported to different database systems . Here I was thinking that modern RDMSs supported a standard set of SQL commands…
So imagine my surprise when I issued
SELECT * FROM table_1 JOIN table_2 ON table_1.id = table_2.id
Because clearly, Interbase expects the verbose
SELECT *.table_1, *.table_2 FROM table_1 JOIN table_2 ON table_1.id = table_2.id
Or am I just stupid?