> On 1 Aug 2014, at 4:45pm, Jim Callahan <jim.callahan.orla...@gmail.com> wrote:
> column is not present in both tables This is usually the result of using the syntax "JOIN table USING column" because SQL requires columns of that name to be present in both tables. Instead of that phrasing see if you can use this one: JOIN thattable ON thattable.thatcolumn = thistable.thiscolumn If that doesn't help ... > SQLite Version 3.8.0.1 Is that the version your IPython interface is using ? Can you give us the output of SELECT sqlite_version() when done through the iPython interface ? And I'm afraid we may also need to see the view definition, so can you tell us whatever you used for your CREATE VIEW command ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
