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
