The error says it. You need to have the same number of columns/fields. For example, this would throw an error if processors had 3 fields and storage had 4. I don't think the names of the fields are important, as it'll use whatever is defined in the first SELECT.
On Tue, Feb 28, 2017 at 8:40 PM, <do...@mail.com> wrote: > # SELECT * FROM processors UNION SELECT * FROM storage; > Error: SELECTs to the left and right do not have the same number of > result columns. > > All tables that I created in my database have differing column names, > values, and amounts of columns with the noted exception of the one > column which is common (board). I've no idea what to do now. > > Why is this an error? > > Thank you, > David > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
