return top 3 fields for each row in another table

[pluciorx]

Hi !
I have a 3 tables linked together:

SELECT ImeiList.[IMEI IN], SBE_LIBELLES.COMMENTAIRE AS Status, SBE_HISTOFICHES.DATECRE
FROM ImeiList INNER JOIN (SBE_HISTOFICHES INNER JOIN SBE_LIBELLES ON SBE_HISTOFICHES.VISA = SBE_LIBELLES.LIGNE) ON ImeiList.[IMEI IN] = SBE_HISTOFICHES.NUMIMEI
WHERE (((SBE_LIBELLES.COMMENTAIRE)="BER") AND ((SBE_HISTOFICHES.METIER)="1") AND ((SBE_HISTOFICHES.SITEGEO)="31") AND ((SBE_LIBELLES.ENTETE)=22));

and i want to return top 3 results from HISTOFISHES linked with LIbelles for each [IMEI IN] in ImeiList

How to perform that ?

Thanks for any advice.

 

[pbaldy]

Not positive I understand, but is this what you want?

http://support.microsoft.com/kb/153747/en-us

 

[pluciorx]

yes but with over 8000 records it doesn't work at all i need a different way to do that.

 

[pbaldy]

Which method? I use the first one on a table with over 100,000 records.

 

[It_thug]

Which method? I use the first one on a table with over 100,000 records.

Thank you Paul. I've been searching for that all morning, but wasn't using the right keywords.