Our Products use Collections, and I am trying to create a SQL Query that will display the contents of one Collection, but will exclude from this Collection, the contents of another Collection.

The Table in question is: AeXNSCollectionMembership

It has two Columns:
CollectionGuid and WrkstaId
__________________

Select * from aexnscollectionmembership where collectionguid = 'blah blah'

This displays the contents of that Collection in GUID and WrkstaId format.
__________________

What I need it to do though, is to reference another Collections contents, that will contain some of the other Collections contents as well (WrkstaId's), so that the other Collection does not display them in its results.

Any ideas?

__________________
If it's not written down, then it never happened!

Report this post to a moderator

Nest a query in the original piece of your syntax, so that the answer of the original statement is the result of the referenced queries lookup

- Swig

__________________
Click here to email me

Report this post to a moderator