sql

Hi there, I'm hoping a SQL ninja will find it in his or her heart to provide me with some advice.

I've created a page view which does the following:

1. Pulls in nodes from two different content types
2. Filters by two different term references, one for each content type.

It's not working, although in my mind (and limited sql understanding), it should. I think maybe there's an issue with the inner joins, because it seems the sql statement would working if they weren't there.

Anyways, I've attached two images, one of the api and one of the actual sql statement.