Re: Select rows when all all ids of its children records matches

[Arup Rakshit <ar@xxxxxxx>]

Can you show me the SQL construction? Do I need to use `WITH`?

Thanks,

Arup Rakshit

ar@xxxxxxx

On 12-Sep-2018, at 9:13 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Wednesday, September 12, 2018, Arup Rakshit <ar@xxxxxxx> wrote:

IN is OR, I want the AND logic. Select posts which has tag 1, 2 and 3 ( tag ids )

Build arrays and then use the “contains” operator.

David J.