Re: Query matches twice, but not simultaneously...

USING(child) WHERE f1.parent=5 AND f2.parent=7; PB ----- Hobbs, Richard wrote: Hello, I have two tables - one containing messages, and another containing links between messages and other messages in a tree structure (much like a threaded mailing list archiving thing). A single mess

Query matches twice, but not simultaneously...

Hello, I have two tables - one containing messages, and another containing links between messages and other messages in a tree structure (much like a threaded mailing list archiving thing). A single message can have multiple "parents" though, meaning the links table can have several entries for a