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

Reply via email to