Referencing a table and column in SQL statement for inner join

Hi there   I have a HUGE dataset over 10 million rows and a small dataset of 2501 rows. I need to do an inner join from the small to the large - so I only get matching rows from the large dataset ...