Help with a query

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

When I query Table A, I get $ 100. When I join Table B to
Table A in the same query, I get $ 87.

The join is Field 1 and Field 2 in Table A equal to Field
1 and Field 2 in Table B.

The first reason for the difference is there are items in
Field 1 in Table A that are not in Field 1 in Table B.

The second reason is there are items in Table B (Field 2)
that appear multiple times; however, the corresponding
value in Field 1 does not match to Table A, so these
records do not come up in the result.

I'm looking for help in writing a query that will bring in
these records if they meet all of the other criteria. Is
this possible or is the join of Field 1 and Field 2 going
to prevent this. Thanks for your help...
 
Mike -

Can you post the SQL statement of the query or queries that are giving you
these results? We have no idea of what you write here because we don't know
what fields are in your tables, what data are in the fields, which fields
you're using in the query, what type of query you're running, etc.
 
Back
Top