Hi,

select *from test1 a inner join test1 b on a.id = b.id1 limit 2

The above query returns the subset (first 2 rows) from the join result.
But, I need a query in mysql, where in the 'limit' should happen first and then from that 'JOIN' should be performed and result should be returned.

i.e First two rows of the table test1 shoule be selected first and then the given join should be applied to this first two rows and it should be returned. How to do this with mysql query ?

Thanks,
Sam