On 13/03/2009 9:30 AM, Derek Developer wrote: > Hello, > There is no need to get upset. I am trying to simplify the table names and > column names to make your life easier...
I am not upset. Our lives would be easier if you showed *exactly* what your input was. Please don't bother trying to simplify things by doing on the fly translations in your messages. If you want to simplify things, produce a simple test case with 2 data bases and one table each and then copy/paste the whole story from your console. > > 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 Rule 1: Assume nothing. Demand proof. > > I then implemented the suggestion: > > well, for one, do you have an "ATTACH 'DatabseTwo.sdb' AS db2" first? ... otherwise we suspect typing mistakes just like the "a" that someone left out of the above line. > > > 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. So produce believable evidence. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
