Tuesday, February 12, 2008

GalaXQL - Interactive SQL tutorial

GalaXQL - Interactive SQL tutorial

Who said SQL tutorials have to be boring?

WQL to SQL
This SQL Query can be used to see how WQL is converted to SQL by SMS for collections.
SelectCollections.SiteID, Collections.CollectionName, Collection_Rules.QueryName, Collection_Rules_SQL.WQL, Collection_Rules_SQL.SQL From Collections,Collection_Rules, Collection_Rules_SQLWhere Collections.CollectionID = Collection_Rules.CollectionIDAND Collections.CollectionID = Collection_Rules_SQL.CollectionID

No comments: