On 12/03/2009 11:15 PM, Derek Developer wrote: > Thank you for all your help. > The ATTACH works ok but still not able to execute the query > > LEFT OUTER JOIN db2.TableTwo n ON n.MyID=d.MyID .... > > Error = UNKNOWN TABLE db2.TableTwo
(1) ATTACH "works OK"?? Do you mean "doesn't get an error message"? We don't have crystal balls. *Show* us the ATTACH statement. Is your code so top-secret that you can't copy/paste the actual code that you ran? Or are "TableTwo" and "MyID" the actual names you've used? (2) Demonstrate that there is a "TableTwo" table in the atatched database. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users