CodingForums.com - View Single Post - Having problems with UNION and GROUP, help greatly appreciated

katyD · 04-27-2012, 04:06 PM

Thanks Old Pendant! That is close, but it shouldn't be showing duplicate catIDs. The subsetOf establishing the hierarchy of the items in the pagesCats table, so it ties to the pagesCats.ID

04-27-2012, 04:06 PM	PM User \| #9
katyD New to the CF scene Join Date: Apr 2012 Posts: 6 Thanks: 5 Thanked 0 Times in 0 Posts	Thanks Old Pendant! That is close, but it shouldn't be showing duplicate catIDs. The subsetOf establishing the hierarchy of the items in the pagesCats table, so it ties to the pagesCats.ID