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 Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-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