On 12/03/2009 12:12 AM, Derek Developer 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?
The fact that you need to supply not a filename but a database-name. See http://www.sqlite.org/syntaxdiagrams.html#single-source What's a database-name? See http://www.sqlite.org/lang_attach.html HTH, John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users