Thread: Having problems with UNION and GROUP, help greatly appreciated
View Single Post
Old 04-26-2012, 03:02 PM   PM User | #3
katyD
New to the CF scene

 
Join Date: Apr 2012
Posts: 6
Thanks: 5
Thanked 0 Times in 0 Posts
katyD is an unknown quantity at this point
Sorry for the sore head

The database structure (simplified), is:

TABLE: pages
ID
pageName
webName
sortBy

TABLE: pagesCats
ID
value
subsetOf

TABLE: pagesIndex
ID
pageID
catID

I've attached a zip of the database, thought this might be of use as well.
Attached Files
File Type: zip 20120426-sample-sql.zip (10.8 KB, 33 views)
katyD is offline   Reply With Quote