Select Client Banners if Exists banner for this client

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('a.*');
$query->from($db->quoteName('#__banner_clients', 'a'))
    ->join('INNER', $db->quoteName('#__banners', 'b') . ' ON (' . $db->quoteName('b.cid') . ' = ' . $db->quoteName('a.id') . ')')
    ->order($db->quoteName('a.name') . 'ASC');
$db->setQuery($query);
$results = $db->loadObjectList();