| ||||||
Here I was thinking that modern RDMS’s 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 = [...]  I got stuck writing a query for Firebird today. And here I was thinking that SQL was a standard — if only the “S” was for “Standard”… I was busy writing scripts at work to paginate results in our BI portals. In MySQL I would usually write something like this to return the first 20 records: SELECT * FROM [...] |    | |||||
Copyright © 2012 stylus - All Rights Reserved | ||||||
