24 December 2009

Query7: Show when a filter has being last updated

SELECT     Item.Name, Collection.LastUpdated, Collection.LastUpdateEventDate, Item.Description
FROM         Collection INNER JOIN
                      Item ON Collection.Guid = Item.Guid
ORDER BY Collection.LastUpdated DESC

No comments: