Hi Armin, could the following select statement give you the result you desired ?
SELECT id, COUNT(*) FROM foo WHERE (pos,txt) in (
(1,'foo'),
(2,'bar'),
(3,'baz'),
(4,'biz') )
GROUP BY id HAVING COUNT(*) = 4
Sincerely,
Dirk Zoettl
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
