> The important schema:
> TBL: ISSUE
> PK:  IssueID
>
> One to many relation to:
> TBL: PAGE
> PK:  PageID
> FK:  IssueID
>
> One to many relation to the table with values I'm checking:
> TBL: PAGEDETAILS
> PK:  PageDetailsID
> FK:  PageID
> BrandID
> RateDetailID
>
> So each issue can have many pages, and each page can have many page
> details.
> I want to select the Issues which have no related pagedetails with null
> values in brandid or ratedetailid.
>
> I've tried many variations of the following query, but to no avail. I
> can't seem to wrap my head around the logic.
>
> SELECT ISSUE.IssueID from ISSUE where ISSUE.IssueID not in(SELECT
> ISSUE.IssueID
> FROM         ISSUE INNER JOIN
>                       PAGE ON ISSUE.IssueID = PAGE.IssueID INNER JOIN
>                       PAGEDETAILS ON PAGE.PageID = PAGEDETAILS.PageID
> WHERE     (PAGEDETAILS.BrandID IS NULL) OR (PAGEDETAILS.RateDetailID IS
> NULL))
>
>
> I've tried with outer joins, using not exists, and a couple other
> things, but can't seem to get it to work properly. Does anyone see the
> flaw in my query?
>