On 29 Jul 2014, at 12:27am, Scott Robison <sc...@casaderobison.com> wrote:
> On Mon, Jul 28, 2014 at 4:20 PM, Simon Slavin <slav...@bigfraud.org> wrote: > >> First and most important, a "FROM" clause is required for every "SELECT" >> command [1]. So the statement, whatever it's meant to do, definitely needs >> to be "FROM" something. There's only two tables used in the example, so it >> would have to be "FROM Customers" or "FROM Orders". > > While it is true most (all?) useful SELECT statements will have a FROM > clause, it is not true that all SELECT statements must have a FROM clause: > > SELECT 1.0/3.0 > SELECT sqlite_version(); True. That's what my footnote number 1 was about. You can also have a SELECT return fewer rows than are in a table using clauses like WHERE. It was a simplified explanation. Because it's easier to understand those. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users