SQL WHERE statement (catid prob)

[nycreate]

Hi all,
this maybe a simple one, but im struggling to work it out..

in Fabrik 2 I had a database join

'WHERE sectiontid = X' to filter articles

This showed everything in all categories in that section.

When I use this in J2.5 and Fabrik3 as they are all nested categories I don't get the same result if I use

'WHERE catid = X' This doesnt show content of the categories nested within.

Any Ideas?

Regards

 

[troester]

I think you'll need something like
WHERE catid = X or catid in (select id from #_categories where parent_id =X)

 

[nycreate]

Perfect! Thanks Troester.