Join query with limit results
<pre><code>ID  Name
1   A
2   B
3   C
4   D
5   E
6   F
7   G
8   H
9   I
10  J
</code></pre>

<p>And other table is </p>

<pre><code>ID  Image   Date
1   aa.jpg  5/17/2016
1   bb.jpg  5/20/2016
1   aa1.jpg 5/15/2016
2   1.jpg   5/17/2016
3   2.jpg   5/17/2016
3   3.jpg   5/20/2016
4   x.jpg   5/17/2016
8   tt.jpg  5/17/2016
9   ww.jpg  5/21/2016
10  21.jpg  5/17/2016
5   67.jpg  5/17/2016
6   3d.jpg  5/17/2016
7   w3.jpg  4/17/2016
7   y78.jpg 5/17/2016
</code></pre>

<p>I have written below query to get this result.</p>

<pre><code>select t1.id,t1.name,t2.image,t2.date 
from emp t1 
join images t2 ON t1.id = t2.id
</code></pre>

<p>result:</p>

<pre><code>ID  Name    Images  Date
2   B       1.jpg   5/17/2016
1   A       bb.jpg  5/20/2016
1   A       aa1.jpg 5/15/2016
1   A       aa.jpg  5/17/2016
.           
.           
.           
</code></pre>

<p>Here is my actual problem:
I have to add limit functionality like limit 0,100. in my limit 0,3
So my expectation is if any id coming with query so all id should be come.</p>