Re: Query for finding keys (IDs) that only have one of two values associated with it

[Sean Griffin]

Thanks very much Rick. I can't thank you enough for taking the time to come up with these options. I tried running the second solution, but it unfortunately does not come back with any rows (only the post_id column is shown). I'm wondering if that is because there is no row for _VenueLat?
That is, there is no NULL value in the meta_value for _VenueLat; if a post_id has no _VenueLat, the row doesn't exist. Is there another solution that could be used to ? Thanks again.

PS - I did try the second option without "AND b.post_id IS NULL" which worked and returned all post_id's that do have a _VenueLat, so the hurdle seems to be using the IS NULL