On 15-09-2010 11:36, Benoit Mortgat wrote: > On Tue, Sep 14, 2010 at 23:41, Stef Mientki <stef.mien...@gmail.com> wrote: > >> until a few moments ago, this worked perfectly >> >> select Header from vraag >> natural join vraaglist >> where Nr = 0 and vraaglist.Name = 'eortc_br23' >> >> but now it returns an empty string (while the string shouldn't be empty). >> >> I test that by doing an explicit join >> >> select Header from vraag >> join vraaglist on vraag.vlid = vraaglist.vlid >> where Nr = 0 and vraaglist.Name = 'eortc_br23' >> > Are you sure that after altering your tables adding columns, natural join > still only joins on vlid? > no, very stupid of me !! I added a column to each of the tables, with the same name, they should have the same value, but due to another programming error, the values were different. again, thank all very much !!
That brings another issue to my mind, which I still don't understand: "why can we so easily manipulate complex pages of text, by adding / deleting / copying / pasting etc, and is manipulating of a few tables in a database so difficult?" cheers, Stef _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
