On Fri, Mar 14, 2014 at 4:22 AM, <random...@fastmail.us> wrote: > DUAL is an Oracle thing. It used to have two rows, in order to be used > to duplicate results by doing a cartesian join to it. At some point, > that was removed, but the name stuck. > > Most other servers allow SELECT without FROM.
Yeah, I usually use PostgreSQL which does. I don't remember what DB2 has. MySQL I think requires either DUAL or an actual real table. ChrisA -- https://mail.python.org/mailman/listinfo/python-list
