Question: review table has store\_idx, user\_idx etc...

I want to create a query sentence that gets information about the store to which the user has bookmarked with the user\_id value entered.

The query sentence I made is

```
select A.store_name
     , A.store_img
     , count(B.store_idx) as review_cnt 
  from board.store A 
  Left 
  Join board.review B 
    On A.store_idx is B.store_idx 
 where store_idx is (select A.store_idx from bookmark where user_id = ?)

```

However, nothing came out as a result.

Help me..

Answer: 
It should be 

```
<select ng-model="blisterPackTemplateSelected"
        data-ng-options="blisterPackTemplate.name as blisterPackTemplate.name for 
                         blisterPackTemplate in blisterPackTemplates">

```

[Check this fiddle](http://jsfiddle.net/akjbcpcL/)
I think you must have the same model in array which you use in dropdown like this which you use for selected.

```
<div ng-app="App" >
     <div ng-controller="ctrl">
       <select  ng-model="blisterPackTemplateSelected"
         data-ng-options="blisterPackTemplate.name as blisterPackTemplate.name 
        for blisterPackTemplate in blisterPackTemplates">
        <option value="">Select Account</option>
       </select>
       <hr>
        <input type="text" ng-model="blisterPackTemplateSelected" />
     </div>       
    </div>

        var app=angular.module('App', []);

    function ctrl($scope){
        $scope.itemList=[];
        $scope.blisterPackTemplateSelected = 'blue'
        $scope.blisterPackTemplates=[{id:1,name:"a"},{id:2,name:"b"},{id:4,name:"c"},{id:3,name:"blue"}]
    }

```