Simon Slavin wrote:
> On 29 Jul 2013, at 4:03am, Fehmi Noyan ISI <[email protected]> wrote:
>> One point I forgot to mention; the number of columns is unknown.
>
> There is no way in SQL to say "Give me the contents of all the columns of a
> row of table in an unambiguous format.".
Well, just "give me" could be done with "SELECT *", but it is almost
impossible to compare such columns in SQL.
If the tables have the same number _and_ names of columns, it would be
possible to use a NATURAL JOIN, and combine this with an outer join to
get non-matching records:
SELECT table1.* FROM table1 NATURAL LEFT JOIN table2 WHERE table2.rowid IS
NULL
This will return those records from table1 that do not have a matching
record in table2. For the other direction, run the same query with
"table1" and "table2" exchanged.
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
