Search results for query: *

I am using MS Access.&nbsp;&nbsp;Would that limit the records in the table to 1 or only limit the matches to 1?&nbsp;&nbsp;the numbers I used were examples.&nbsp;&nbsp;The real tables contain much more data than just 1 row in one table and 3 in the other.&nbsp;&nbsp;<br><br>Thanks,<br>Eve

Basically Table A contains a list of insurance policies while Table B contains a list of accidents.&nbsp;&nbsp;Some 10 or so fields are the same in Table A as in Table B.&nbsp;&nbsp;Those fields are used to find matching records and then those records are joined and placed in Table...

Here's my problem.<br>I've got 2 tables with a lot of the same fields.&nbsp;&nbsp;I am using a SQL query to compare those shared fields and join the matching records into a results table.&nbsp;&nbsp;<br><br>What I've had happening is that there is only 1 record in Table A, but 3 records in Table...