Is there a join for this?

R

razor

Hi,

I have a small table and a huge table.

I would like to join on the Employee_ID field. The
Employee_ID is unique in the small table but appears
multiple times in the huge table.

Is it possible to return all the records in the small
table and all the records in the huge table where the ID
matches?

So If ID 12345 appears once in the small table and appears
5 times in the huge table, I'd like to return all 6
records.

Thanks!

Regards,
Rajat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Auto Merge text from multiple sources 0
Creating a Search using a combo box and then creating a report. 4
Create a distinct Join 3
Insert name and adress from a list in a word document 1
New computer, how do i move outlook 365 ENTIRELY? 0
Active Content in this file is blocked issue 1
Word VBA - Want to test if Full Name is NOT Present in document 0

Top