Angular First SQL retrieve key from Database in array 1 : On screen, need to display text from array2 whose keys corresponds to array1 values

I am displaying values in HTML, with angular JS code snippets. First SQL is run to get values in array1(users). I need to display text from array2(pageafterlogin), which keys(US_DefaultPage) corresponds to values in array1. Which tags should i use?

Already tried ng-if
Using JOINS in SQL cause the system to be slow.

<table>
<tr ng-repeat="c in users | filter:search | orderBy:['US_UserId']" id="{{c.US_UserId}}" animate-on-change='c.US_UserId + c.US_Name + c.US_Status + c.US_DefaultPage + c.US_DefaultRestoId' ng-animate=" 'animate'">

<td>{{c.US_UserId}}</td>
<td>{{c.US_FirstName}} {{c.US_Name}}</td>
<td>{{c.RE_Name}}</td>
<td *ngFor="#page of pageafterlogin; #page.ST_Description=c.US_DefaultPage.trim()">{{page.ST_Code}}</td>
<td>{{c.US_DefaultPage.trim()}}</td> 

</tr>
</table>

Expected (Display Text)
Text1
Text2
Text3

Actual (Display Key)
P1
P2
P3

Source: AngularJS