MySQL database banner

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:

  1. https://en.wikipedia.org/wiki/SQL

By foxbeefly

PHP / MySQL Developer. HTML, CSS and some JavaScript.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.