Hello, There is no need to get upset. I am trying to simplify the table names and column names to make your life easier...
You can assume that I have carefully studied the responses I got and tried everything suggested. I have also read all the links given. Thank you for those I then implemented the suggestion: well, for one, do you have an "ATTACH 'DatabseTwo.sdb' AS db2" first? If yes, you could do SELECT.. FROM TableOne d LEFT OUTER JOIN db2.TableTwo n ON n.MyID=d.MyID WHERE d.Zip > 80000 ORDER BY d.Zip This is not working for me. TableTwo is not found. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users