How to find a List of all the Items not in a Category ?

(inactive)_Alexander_Pachipala

Hi,

For finding "List all of the Items in the specific Category is as here below",

select name, vernum from dtree, llattrdata where dtree.dataid = llattrdata.id and llattrdata.attrtype = -18 and llattrdata.valstr = '<CATEGORY NAME>'

But, I am trying to find out for a List of all the Items not in a specific Category (but the item can contain multiple categories) "

Kindly advice.

Regards,

Alex