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
[1]. 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 and only got fields from table_1 in my result set.
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?
Reference: