On 2/2/2011 11:16 AM, Marco Bambini wrote: > your query returns 3 columns, but I need just two columns (key, value for > example).
Why? You have all the information you need, just in a slightly different (and, arguably, easier to use) form. > The first row should be the label 'ID' and the id of the MKObjects followed > by a SELECT prop_key, prop_value WHERE obj_id= MKObjects.id. Why should it? Why exactly do you insist on this format? What should happen, in your proposed representation, when there is more than row in MKObjects, each with its own set of properties? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users