Livereport non-category

dsta001_dsta001_(dsta001_-_(deleted))

Hi,i able to display out all doc and shorcut that have category attached with the following SQL statment. But how do i do a sql statment that display the doc and shortcut that do not have category attached? Select DTree.*, a.ValStr, a.id from Dtree, LLAttrData a, CatregionMap b where dataid=a.id and b.regionname=('Attr_'||a.defid||'_'||a.attrid) and a.defid in (select catregionMap.CatID from catregionMap where catname='source') and b.attrname='country'I understand that if i remove the table LLAttrData and catregionmap, i can get the doc and shortcut w/o displaying the category info. But it will display those doc with catgory attached to it. I want to display doc and shorcut that do NOT have any category attached. ThanksAny idea of any table that i should look into?