On Wed, Jul 23, 2014 at 12:32 PM, jose isaias cabrera <[email protected] > wrote:
> > Greetings. > > I have two DB identical and I am copying data from one to another. > > When I attach a DB, i.e.. > > ATTACH 'c:\db\mydb.sqlite' as client; > > how do I address the names of the column? for example, both DBs connected > and disconnected have the columns: id,ProjID, Date, code, login. When I do > this command, > > BEGIN; > INSERT OR REPLACE INTO LSOpenProjects > SELECT * FROM client.LSOpenProjects > WHERE client.LSOpenProjects.ProjID <= 133560 AND > Date != client.LSOpenProjects.Date AND > client.LSOpenProjects.login = 'user1'; > END; > > The main.LsOpenProjects is not in scope for the SELECT statement so you can omit the "client.LSOpenProjects." prefix if you like. On the other hand, what you wrote works, so what's the problem? > So, is there a different way of addressing the attached DB table columns? > Any help would be greatly appreciated. thanks. > > josé > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
