Joe wrote:
> my SQLite database has two tables Katalog and ZKatalog with the same
> structure. One of the columns is called DDatum. What's the most efficient
> way to
>
> (1) Select records, which are only in Katalog, but not in ZKatalog?
SELECT * FROM Katalog EXCEPT SELECT * FROM ZKatalog;
> (2) Select records, which are in Katalog and in ZKatalog?
SELECT * FROM Katalog INTERSECT SELECT * FROM ZKatalog;
SELECT * FROM Katalog UNION SELECT * FROM ZKatalog;
(depending on the exact meaning of the word "and" in your question)
> (3) Select records, which are with same column values except DDatum in
> Katalog and in ZKatalog?
SELECT *
FROM Katalog
WHERE the_primary_key_column IN (
SELECT the_primary_key_column FROM (
SELECT all,columns,except,ddatum FROM Katalog
INTERSECT
SELECT all,columns,except,ddatum FROM ZKatalog
)
);
(If you do not need the DDatum values, use only the inner subquery.)
> (4) Select records from Katalog and ZKatalog with same DDatum content?
SELECT * FROM Katalog WHERE DDatum IN (SELECT DDatum FROM ZKatalog);
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
