many to many join

  • Thread starter Thread starter margaret
  • Start date Start date
M

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,
 
margaret said:
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.
Click to expand...
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
 
Back
Top