Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Diego Morales — — source: Informix-list mailing list archive (1991-1998)
Try this, perhaps it works
select * from A where ? = not in (select * from B)
This will select the records of A not in B
select * from B where ? = not in (select * from A)
This will select the records of B not in A
select * from A where ? in (select * from B)
This will select the records of A in B and B in A.
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.