thanks Woody ( Harold ?), that works perfect.
cheers, Stef Harold Wood & Meyuni Gani wrote: > Concantenate or join? > > To concantenate use the > Select * from a > Union all > Select * from b > > Only use * if columns all columns in a are identical to all columns in b, if > not then build a column list and use that indtead of * > > Woody > > -----Original Message----- > From: Stef Mientki <s.mien...@ru.nl> > Sent: Saturday, July 25, 2009 3:19 PM > To: SQLite List <sqlite-users@sqlite.org> > Subject: [sqlite] Is there an easy way to concatenate 2 views ? > > hello, > > I've 2 views ( or maybe tables) with same columns, > is there an easy way to concatenate those 2 views to 1 new view ? > > thanks, > Stef Mientki > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users