-
☆ A M B ☆
- 1,231 Posts
Hello,
I’m trying to get documents from multiple parents in a TV but not having any luck. I’ve tried the following but it’s not working right. It just displays 1 resource but it appears blank so I assume it’s not working at all. If I remove the second `parent` call it does work so how do I get from multiple parents?
@SELECT `pagetitle`,`id` FROM `[[+PREFIX]]site_content` WHERE `parent` = 109 AND `parent` = 100 AND `published`= 1
Thanks!
*** Solved
WHERE `parent` = IN (100,109)