I don't know the source of the "INTERSECT" command that keeps popping up
on the list but this is a straight-forward JOIN situation if I have ever
seen one.
Please read for more details: http://dev.mysql.com/doc/mysql/en/JOIN.html
SELECT A.*, E.*
FROM A
INNER JOIN B
ON A.ID = B.parentid
Background:
I have one master table A, and other supplementary tables B,C and D such that
for every row of A there can be one or more corresponding rows in B,C,D.
There is another supplementary table E with which A has a one-to-one
relationship.
Problem:
Given three search criteria resulting
