>Hello, I have encountered another problem with my application. I have had to modify the base table structure to allow for a many-to-many relationship where I originally had it setup as only a one-to-many.
>
>I had an SQL SELECT statement that would pull the data from the associated tables I needed and it was working flawlessly, that is, until I changed the table structures.
>
>Now I cannot seem to get the SELECT statement to locate the correct number of records. It either picks none at all, or multiple instances of both records from the two tables.
>
>There are 3 tables involved, 2 have a single primary key (these are the base tables) and another single table which stores the associations between the first two tables. This table has a single primary key and two regular keys that link to the primary keys of the first two tables.
>
>Do I need to use a nested select statement? I have been using filters to define my table relationships, but would it be easier to use the JOIN clause?
>
>Any help would be appreciated. Thanks in advance...
>
>Iain
can we see the select statement you're using?