ca.portal.admin

Re:SQL question

Discussion created by ca.portal.admin on Oct 10, 2008
Hi everyone,

I have a SQL question from a developper that I can't answer. He wants
to get all B records from a set A-B, but only the B that are not an
active member of the set A-B. He tried with NOT A-B, and it doesn't
work. Is there a way to do this in SQL?

Thanks,
Laura Rochon
Ajilon
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: SQL question
"Laura,

Is this an SQL view of a network database? Based upon your question, I
assume it is.

If that is the case, there is no native SQL method by which one can test for
set membership. However, there would be nothing that would prevent one from
writing an SQL (table) procedure to navigate the nDML database and return
rows of ""B"" for which there is no ""parent"" ""A"".

Chuck

Outcomes