I'm using 2.6 final, and I'm trying to figure out how to accomplish the following:
SELECT Ideas.id, Ideas.name, Ideas.description, Ideas.url, Ideas.price, Ideas.createdOn, Ideas.updatedOn, Ideas.properties, Ideas.createdBy, Ideas.updatedBy
FROM IdeaFacets RIGHT OUTER JOIN
Ideas ON IdeaFacets.ideaId = Ideas.id
WHERE (IdeaFacets.rootId <> '58540F98-04DF-40D9-8AF7-A42663A03FD9') OR
(IdeaFacets.rootId IS NULL)
My database is a standard: Idea - IdeaFacet - Facet deal.
Idea:
Id
IdeaFacet:
IdeaId
FacetId
RootFacetId
Facet:
FacetId
The part that's getting me is saying that the rootid <> some value.
Thanks guys.