On Wed, 11 Mar 2009 06:12:37 -0700 (PDT), Derek Developer <derekdevelo...@yahoo.com> wrote:
>I have read and searched but I am not able to >get the following statement to run: > SELECT MyID, Zip FROM TableOne d > LEFT OUTER JOIN DatabseTwo.sdb.TableTwo n > ON n.MyID=d.MyID WHERE d.Zip > 80000 ORDER BY d.Zip > >I just get error at "." > >I tried specifiying the databse name without the file extension by no joy. >What am I missing here? Perhaps: ATTACH DATABASE 'DatabaseTwo.sdb' AS db2; SELECT MyID, Zip FROM TableOne d LEFT OUTER JOIN db2.TableTwo n ON n.MyID=d.MyID WHERE d.Zip > 80000 ORDER BY d.Zip; DETACH DATABASE db2; -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users