SQL server exams - SQL Syntax Q

Author

SQL Syntax Q

CyberDude

2004-01-24, 9:21 am

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?

Swigga

2004-01-27, 2:17 pm

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

Sponsored Links