SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

List of collection and their parent collection

SELECT
    COL.CollectionID,
    COL.Name,
    COL.Comment,
    CTSC.parentCollectionID
FROM
    dbo.v_Collection COL,
    dbo.v_CollectToSubCollect CTSC
WHERE
    CTSC.subCollectionID = COL.CollectionID

Published Oct 31 2008, 09:19 AM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems