many to many join

[margaret]

I have one table tblcash with cashid; emp; cashdate and other fields. Then
I have another table is tblboothassignment with boothid; emp; fairdate; booth
and other fields. FYI, emp is a one to many join on both tables with
tblemployees.

I need to run a query that pull the emp, and booth assignment with a
matching in the cashdate=fairdate and emp=emp. However, since this a many to
many join, I'm getting multiple lines for every entry.

How can I limit the information. I'm really having trouble wrapping my head
around this.

Thanks,

 

[Bob Barrows [MVP]]

I have one table tblcash with cashid; emp; cashdate and other fields.
Then I have another table is tblboothassignment with boothid; emp;
fairdate; booth and other fields. FYI, emp is a one to many join on
both tables with tblemployees.

I need to run a query that pull the emp, and booth assignment with a
matching in the cashdate=fairdate and emp=emp. However, since this a
many to many join, I'm getting multiple lines for every entry.

How can I limit the information. I'm really having trouble wrapping
my head around this.

Could you show us a few rows of sample data from each table (relevant fields
only, please) and:

1. the results you would wish to obtain from that sample data
2. the sql statement you tried
3. the incorrect results you received