I can not work out methods to choose all assist’s from Drupal Development Service areas desk that don’t exist in Drupal Development Service field_data_field_area_parent desk.

It nearly works, besides it returns Windy Ridge with an “assist” of “11”. I’m guessing that it is because “IN” is Drupal Development Service identical as “ANY”, and Drupal Development Service quantity “1” is in Drupal Development Service subquery outcomes.

How can I take advantage of NOT EXISTS as a substitute of NOT IN?

perform verb_get_parent_areas () {   $question = db_select('areas', 'a');   $query->distinct();   $query->fields('a',array('identify','assist','mum or dad','latitude','longitude','description'));   $subquery = db_select('field_data_field_area_parent', 'p');   $subquery->fields('p', array('entity_id'));   $query->situation('a.assist', $subquery, 'NOT IN');    $consequence = $query->execute();   whereas ($file = $result->fetchAll()) {            $areas = drupal_json_encode($file);   }    return $areas;   exit; } 

I’ve considered making an attempt this, but it surely returns nothing.

perform verb_get_parent_areas () {   $question = db_select('areas', 'a');   $query->distinct();   $query->fields('a',array('identify','assist','mum or dad','latitude','longitude','description'));   $subquery = db_select('field_data_field_area_parent', 'p');   $subquery->fields('p', array('entity_id'));   $query->notExists($subquery);    $consequence = $query->execute();   whereas ($file = $result->fetchAll()) {            $areas = drupal_json_encode($file);   }    return $areas;   exit; }