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